Hi all,
After gathering up as much information about activeX comboboxes from the net as icould find i've pieced together the below code which makes sense to me but doesn't work.
I want the code to loop through ComboBoxes 3 thru 10 (the others to leave alone) and clear each combobox and then populate them with data from a different sheet. the data could have empty cells along the way so i've included in the code to skip over blanks.
Please Login or Register to view this content.
Hello kosherboy,
Try this version of your macro. It should work if your comboBoxes are named "ComboBox1", "ComboBox2", etc.
If you changed the names then the macro will need some changes.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Wow Wow Wow, you really could code!!
Thank you so much
Just noticed this issue:
The first combobox lists the proper info but the second lists it twice and the 3rd one lists it 3 times and so on and so forth.
Any way around this?
I changed some parts of your code and now it works
Please Login or Register to view this content.
Hello kosherboy,
Great job on fixing the problem!
Sorry about that. I have been interrupted by phone calls all morning. While my code is a little more involved, it is faster because it assigns an array of all values to the ComboBox list.
Here is the corrected code.
Please Login or Register to view this content.
Thanks
B regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks