Thread: Start a macro when a vlooup formula shows a new value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
  
Posts: 3,355
Default Start a macro when a vlooup formula shows a new value
Take a look at Worksheet Change events and think about having it fire when
you change the value that is used for the VLOOKUP.

You can read more about events here.

http://www.mvps.org/dmcritchie/excel/event.htm
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Arno" wrote:

Hello,

I have cell A3 with vlookup formula.

Every time a new value is shown in A3 I would like to start /call a macro
automatically in that same worksheet.

Could you please assist with the syntax


Thank you !

Arno

Reply With QuoteReply With Quote