I received the following code from a question I had earlier. It prefills ComboBox1 in a UserForm with numbers ranging from -3 to +3 and is defaulted to 0. Is there a way to make this code applicable to multiple ComboBoxes without copying it over and over and changing the number? Like maybe something like ComboBox1,3,6,11,14,23,65.AddItem "+3" and so forth? I know that doesn't work, I'm just trying to streamline.
Please Login or Register to view this content.
Last edited by ZIXILPLIX; 05-02-2010 at 12:59 PM.
Hi ZIXILPLIX
some thing like
Please Login or Register to view this content.
Pike,
Thanks a lot for your help on this, but I keep on getting the following error - Compile error: For Each control variable must be Variant or Object. Any idea what I am doing wrong?
ops ... i as a variant not a byte
You are a genius!! Thanks a million!!
You say "a genius" most testify crazy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks