Hi there. I want to make a dropbox choice run an independant macro for this choice. I've looked on forums , everywhere And i just can't get it to work. When i run the macro from the Sheet code, it works. But the minute i try it , it pops the error : Sub or fonction not defined..
My macros are placed on a module but the one for the dropbox is on sheet1. Heres my code:
Private Sub worksheet_Change(ByVal Target As Excel.Range)
Select Case Target.Range("$E$1").Value
Case "Draconien"
Call Draconien_init
Case "Fenrae"
Call Fenrae_init
Case "Third macro Name"
Call Third_Marco
Case "Fourth macro Name"
Call Fourth_Marco
End Select
End Sub
End Sub
- The first line is highlighted when the error pops.
Can someone explain to me what i'm doing wrong?? Thanks!
Bookmarks