run macro with input msg based on cell input

J

Janelle S

I need help to run a macro with input msg when a date is entered into the
cell eg. date is input to cell M20 - input message "Budget received - do you
want to complete Budget Calculator" If "Yes" is selected then worksheet
"Budget Calc" is copied and renamed based on contents of cell A2 (I think I
have the renaming sorted thanks to previous posts). If "No" selected then
macro stops.
Any help would be appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro with input msg based on cell contents 2
Text Box contents to cell comments 5
Copy worksheets and save files dynamically 3
Selecting all cells with content using a variable 3
Duplicate and rename 1
input field linked to button to create a table 5
One click date + predefined text input. 3
Conditional Formatting - Input Time Delays 3

Top