Hi everyone,
I'm trying to populate a dropdown box in excel using VBA.
I have a dropdown already in excel, created using data validation, but its empty. What I want to do is, based on the value of another cell, populate this dropdown box with values using VBA. I realise that this can be done in excel, but, just for interest sake, and also as it would require a lot of manual input otherwise, I would like to do it using VBA.
Any help would be great.
Thanks!
Do you have a sample file that you can upload?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
You can use INDIRECT to populate it with different named ranges, no need for VBA.
If you want vba again use named ranges & record a macro to get the general code
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
MikeFranz123 
Register To Reply
Bookmarks