Currently i am working on a combo box where i wish to select only one cell in the column G18 (drop down list - a full displayed table with all information), then the remaining information on blue box of G19 until G23 will be filled up according to the drop down list displayed table accordingly.
Can anyone please advise on what's the visual basic code i should write to get this fuction works?
No point attaching a word document with a picture of a spreadsheet.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hi Roy. Thanks for your advice. Attached herewith is the template for the problem that i am having as i mention in the thread earlier. Can anyone in this forum please help advise?
Thanks.
I really can't see why you are over complicating this with VBA.
A simple Data Validation List and VLOOKUP would achieve this
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks