+ Reply to Thread
Results 1 to 3 of 3

call macro from combo box

Hybrid View

  1. #1
    Registered User
    Join Date
    05-17-2007
    Posts
    45

    call macro from combo box

    I had some help earlier; where I'm trying to have a macro run once its selected from a combo box - and this code works well:
     Private Sub ComboBox1_Change()
    
    Select Case ComboBox1.Value
       Case 1
         Call Macro1
       Case 2
         Call Macro2
       Case 3
         Call Macro3
       Case 4
         Call Macro4
    End Select
    
    End Sub

    What I'm getting hung up on is the macros only run if its numbers populating the combo box, say if my linked cells read 1-7 that would work but Sunday-Saturday does nothing. Is there something in the properties menu or in the coding that can read numbers but not characters? Thank you
    Last edited by VBA Noob; 05-21-2007 at 01:53 PM.

  2. #2
    Registered User
    Join Date
    11-16-2006
    Posts
    80
    Try:

    Select Case ComboBox1.Value
    
    Case "Monday"
       Call Macro1
    Case "Tuesday"
       Call Macro2
    Case "Wednesday"
       Call Macro3
    Case "Thursday"
       Call Macro4
    Case "Friday"
       Call Macro5
    Case "Saturday"
       Call Macro6
    Case "Sunday"
       Call Macro7
    
    End Select
    HTH,
    mccreaso

  3. #3
    Registered User
    Join Date
    05-17-2007
    Posts
    45
    its that easy eh? alright, thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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