Hi !
If i have a userform with 2 comboboxes (ComboBox1 and ComboBox2) and a commandbutton (CommandButton1)
If i select "Hello" in ComboBox1 and "Goodbye" in ComboBox2 and click on CommandButton1
i want cell A1 in active sheet to change color to red.
I have manage to get this to work whit one combobox using "Select Else" statement but struggeling to
get it to work whit multiple comboboxes.
Best Regards
Petter
Last edited by Petter120; 05-05-2012 at 05:35 AM.
Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
Thank you it works great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks