Insert Macro into Excel cells

Copper Contributor

Dear all,

 

I created Macros to open a word file (Customer card) automatically. So I would like to affect this macro when I click in a specific cell (related to a Customer line in my database) or in a specific link... 

So when I use the "Vlookup" formula it can bring the link to use the related macro.

Hope I've been clear enough 
Do not hesitate to ask me further infos.

Thanks a lot in advance for your help
Kind Regards

Max
 

 

1 Reply

Auto-answer :

 

 

 

If Range("CELL") = "CUSTOMER NUMBER" Then
Call MacroNUMBER
End If