Hi,
I have a user form with two combo boxes, the code below is what i used when only had one combo box, but when i use the same code one for each combo box, only one will work, obviously i did change the code to combo box 2 for the second one.
please can anyone give me an idea where i went wrong.
many thanks for reading
Please Login or Register to view this content.Please Login or Register to view this content.
many thanks for reading and hopefully helping.
What exact code are you using for 2 comboboxes?
If posting code please use code tags, see here.
the code i used for one box as above, then entered again with a different range and box name
I think perhaps all the code for the two boxes should be together but nothing I have tried so far works, thank you for taking the time to look, maybe you can give me a code that will work.
It's not 100% clear what code you have.
If you just copied that code then you would get a ambiguous name detected on the UserForm_Initialize event.
that is exactley what happened, here is the code i used.
i tried just deleting initialize on the second lot of code, but the second combo box still did not workPlease Login or Register to view this content.
Last edited by robert.begley1; 12-01-2012 at 01:31 PM. Reason: spelling mistake
Try this.
Please Login or Register to view this content.
you are a genius, thank you so much, I have added to your reputation
Thanks Robert, was kind of worried it might not work for the Mac.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks