Hey
Just wondering if anyone knew of a macro that would allow for a command button to click if a specific cell is changed to a specific value?
Thanks
Hey
Just wondering if anyone knew of a macro that would allow for a command button to click if a specific cell is changed to a specific value?
Thanks
Last edited by Taz97; 01-25-2018 at 10:11 AM.
Put this in the code behind the worksheet (not in a module)
Please Login or Register to view this content.
Design everything to be as simple as possible, but no simpler.
?
ps: 'CommandButton' must have the name "CommandButton1" or you must change it to another, in the code as well.Please Login or Register to view this content.
Last edited by mjr veverka; 01-25-2018 at 11:24 AM.
Thanks this works!
However just wondering if there was a way to trigger the button with a time inserted into the specific cell and not just one specific entry?
What do you mean? And whose code did you use (so we can help specifically)?
?
In my code for example, instead of:
insertPlease Login or Register to view this content.
and make a check (e.g. function) of the "time entry" format in the "specific cell".Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks