• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro used in IF formula.

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
 
Back
Top