ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   assigning macros to a text link or create a drop down box (https://www.excelbanter.com/excel-programming/292654-assigning-macros-text-link-create-drop-down-box.html)

arizona302

assigning macros to a text link or create a drop down box
 
I can't figure out how to assign macros to text or how to create a dro
down box with each choice linked to a macro? Does this make sense -
can I do this? Help!! Thanks

--
Message posted from http://www.ExcelForum.com


Tom Ogilvy

assigning macros to a text link or create a drop down box
 
Use data validation (List option) and the change event if you are using
xl2000 or later.

--
Regards,
Tom Ogilvy

"arizona302 " wrote in message
...
I can't figure out how to assign macros to text or how to create a drop
down box with each choice linked to a macro? Does this make sense - -
can I do this? Help!! Thanks.


---
Message posted from http://www.ExcelForum.com/





All times are GMT +1. The time now is 09:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com