Forum Discussion

LOPEZ Maxime's avatar
LOPEZ Maxime
Copper Contributor
Jun 18, 2018

Insert Macro into Excel cells

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
 

 

  • LOPEZ Maxime's avatar
    LOPEZ Maxime
    Copper Contributor

    Auto-answer :

     

     

     

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

Resources