W wrbrown New Member Sep 12, 2010 #1 Can a Macroe be used in a IF formula and if so how is it writen. Thanks.
Hui Excel Ninja Staff member Sep 12, 2010 #2 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
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