I have searched high and low! I cannot get a combo box to run a macro. I have tried select.case and If statements. Please help!
All I want is when I select a value from the combo box and press button 1, Macro1 will run.
See attached workbook and "fix" and post back to the thread if you can. I have XLSM for 2007 & 2010 and XLS for 2003 users.
I would appreciate this very much!!
Last edited by 4am; 12-08-2010 at 05:01 PM.
If you assign a cell link to your box (e.g. K1) then you can use this single line:
Please Login or Register to view this content.
Hello 4am,
Here is code for the button.
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!)
Leith Ross, you are an Excel star!! Thank you so very much!
What code would you use if the name of the macro differed from the value in the combo box?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks