LinkBack URL
About LinkBacks
I have a cell which is "data validated" for a list.
I want to trigger a macro when I make a selection of the validated data, in other words, run a macro when selection done in the dropdown cell.
Any good ideas?
Thanks
I have a cell which is "data validated" for a list.
I want to trigger a macro when I make a selection of the validated data, in other words, run a macro when selection done in the dropdown cell.
Any good ideas?
Thanks
You will need a worksheet change event.
http://www.ozgrid.com/VBA/run-macros-change.htm
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I tried that, but I can not find the option for "making selection"; there are options for CALCULATE, ACTIVATE,CHANGE etc., but none of these works for a dropdown selection within a validated cell. Am I doing something wrong?
Thanks
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Attached, please find the file; when you open it, you will see a green cell which contains "ORANGE"; that cell is a DATA VALIDATED CELL.What I am trying to achieve is that the moment I make a selection in that green cell, I want to trigger a macro; for now if I could get a MsgBox "Macro Triggered", it would be good enough; I could take it from there.
Thank you very much for the quick response!
Put this in the worksheet events
See attached
Please Login or Register to view this content.
Amazing! It works perfect.
Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks