Results 1 to 18 of 18

Dropbox choice runs macro Error ??

Threaded View

  1. #1
    Registered User
    Join Date
    05-30-2011
    Location
    Montreal
    MS-Off Ver
    Excel 2003
    Posts
    9

    Exclamation Dropbox choice runs macro Error ??

    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!
    Last edited by Eliann; 05-30-2011 at 07:07 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1