-
Excel Combobox used as a pick list to populate different cells
Hi,
I am enhancing an invoice application I am developing and have been toying with the idea of using a combo box to select from a list a particular product and put the value in a cell. It works fine, although I have some other aspects of it which I will try and sort later.
My immediate problem is that, I need to repeat teh selection process from teh Combobox, for each lien of teh invoice ( some 10 lines) on each occasion droping teh value in a different cell. ie D20, D21, D22, D30. Is there a way of doing that? I am using the linkedcell function of the Combobox property. and it works well for the first time. Is there a way of using a VBA incremental function to increase d20 to d30 step by step?
Thanks for any help.
Talāt
-
Move away from the linked cell (which I've never like anyway - it is way too constrictive) and do what you need to do through VBA programming code.
-
Thanks Hack.
Unfortunately, my VBA skill are not up to it. With the linked cell option, I thought I was almost there. But if you say, it can't be done, then I think its time I give up.
Similar Threads
-
By Hack in forum VB Classic
Replies: 2
Last Post: 08-05-2008, 12:13 PM
-
By RipIT in forum VB Classic
Replies: 27
Last Post: 02-21-2008, 08:01 AM
-
By iinfoque in forum ASP.NET
Replies: 0
Last Post: 03-11-2007, 09:14 AM
-
By software_develo in forum .NET
Replies: 0
Last Post: 08-07-2006, 10:31 PM
-
By amiradar in forum VB Classic
Replies: 7
Last Post: 05-11-2005, 03:56 PM
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|