Macro used in IF formula.
- Thread starter wrbrown
- Start date
wrbrown
This can't be done as you suggest.
But you have 2 options
1. Write a function which will do what you want
2. Write a Macro which watches a cells value and then does something
You do this by using the worksheet's Change event which can monitor a Target Cell and checking a value and running some code or another macro if required
This can't be done as you suggest.
But you have 2 options
1. Write a function which will do what you want
2. Write a Macro which watches a cells value and then does something
You do this by using the worksheet's Change event which can monitor a Target Cell and checking a value and running some code or another macro if required