Results 1 to 1 of 1

Trouble with Comboboxes

Threaded View

  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    73

    Trouble with Comboboxes

    Hey guys,
    Trying to have a combobox on a splash screen, where depending on what is selected, variables are assigned certain values. Here is what I've got:



    Sub LaunchGen() 
         '
         ' LaunchGen Macro
         '
         
         '
        Dim QD As Shape 
        Dim sht As Worksheet 
        Set sht = ThisWorkbook.Worksheets("Generator") 
        Set QD = sht.Shapes("QuarterDropdown") 
         
        Select Case QtrYr 
             
        Case QD.Value = "Q1 2015" 
            YearQTR = "20151" 
            SummaryString = "Scorecard - 1st Quarter 2015" 
            CostString = "Cost - 1st Quarter 2015" 
            QualityString = "Quality - 1st Quarter 2015" 
            ScheduleString = "Schedule - 1st Quarter 2015" 
             
        Case QD.Value = "Q2 2015" 
            YearQTR = "20152" 
            SummaryString = "Scorecard - 2nd Quarter 2015" 
            CostString = "Cost - 2nd Quarter 2015" 
            QualityString = "Quality - 2nd Quarter 2015" 
            ScheduleString = "Schedule - 2nd Quarter 2015" 
    
        Case QD.Value = "Q3 2015"
            YearQTR = "20153"
            SummaryString = "Scorecard - 3rd Quarter 2015"
            CostString = "Cost - 3rd Quarter 2015"
            QualityString = "Quality - 3rd Quarter 2015"
            ScheduleString = "Schedule - 3rd Quarter 2015"
    
    End Select
    
    GenerateScorecard
        
    End Sub
    The error I get is: "Object doesn't support this property or method".
    Any ideas? Thanks.

    EDIT: Got it. Changed to ActiveX combobox and did this:

    Select Case QtrYr
    
        Case Sheets("Generator").QuarterDropdown.Value = "Q1 2015"
            YearQTR = "20151"
            SummaryString = "Scorecard - 1st Quarter 2015"
            CostString = "Cost - 1st Quarter 2015"
            QualityString = "Quality - 1st Quarter 2015"
            ScheduleString = "Schedule - 1st Quarter 2015"
            
        Case Sheets("Generator").QuarterDropdown.Value = "Q2 2015"
            YearQTR = "20152"
            SummaryString = "Scorecard - 2nd Quarter 2015"
            CostString = "Cost - 2nd Quarter 2015"
            QualityString = "Quality - 2nd Quarter 2015"
            ScheduleString = "Schedule - 2nd Quarter 2015"
            
        Case Sheets("Generator").QuarterDropdown.Value = "Q3 2015"
            YearQTR = "20153"
            SummaryString = "Scorecard - 3rd Quarter 2015"
            CostString = "Cost - 3rd Quarter 2015"
            QualityString = "Quality - 3rd Quarter 2015"
            ScheduleString = "Schedule - 3rd Quarter 2015"
    Last edited by jsabo; 09-14-2015 at 07:23 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 02-18-2015, 02:02 PM
  2. Help! Entire Row Hidden - w/Two ComboBoxes - Doesn't Hide the ComboBoxes
    By ocnmel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-06-2015, 09:27 AM
  3. filtering comboboxes depend on value of other comboboxes
    By hassan khansa in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-18-2014, 09:18 AM
  4. Comboboxes
    By Sniper in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-27-2009, 08:40 AM
  5. [SOLVED] OLE comboboxes
    By Mikkan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2005, 08:05 PM
  6. Need help with ComboBoxes.
    By rosemary in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-08-2005, 08:05 PM
  7. Comboboxes
    By Darren in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2005, 02:06 PM

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