Combobox not selecting value

JHogan0721

New Member
Joined
Dec 7, 2016
Messages
12
I am new to VBA and working on a userform but am ready to pull my hair out with something I fear is very simple. I have a combobox (Cntrl2) that I want to populate with manager names. I have a range titled DMNames that I set as my rowsource property for the combobox. This works fine and when I click the box the names populate perfect. The trouble starts when I try to select one of the names when testing the userform. All names show up but I can't select them. I have multiple userforms for this project and have the same manager combobox on another form that works perfectly. I have compared all the properties to ensure that the box is not locked, other textboxes allow for data entry so I don't believe to userform is locked. I am at a loss. I have this combobox set to populate another box after selection has been made. Below are some details that may help.

Combobox = Cntrl2
Locked Property = False
RowSource Property = DMNames (a static range from worksheet "List Values" cells k2:k8)

Here is the code attached to Cntrl2 that populates the next combobox (Cntrl3)
Code:
Private Sub Cntrl2_Change()
Me.Cntrl2 = ""
Select Case Me.Cntrl2 'provide rep auto-fill info based on DM name'
    Case "Brad Ward"
        Me.Cntrl3.RowSource = "Brad_Ward_Rep_Names"
    Case "David Bible"
        Me.Cntrl3.RowSource = "David_Bible_Rep_Names"
    Case "Justin Brooking"
        Me.Cntrl3.RowSource = "Justin_Brooking_Rep_Names"
    Case "Justin Hogan"
        Me.Cntrl3.RowSource = "Justin_Hogan_Rep_Names"
    Case "Mark Thornton"
        Me.Cntrl3.RowSource = "Mark_Thornton_Rep_Names"
    Case "Steve Rosenzweig"
        Me.Cntrl3.RowSource = "Steve_Rosenzweig_Rep_Names"
    Case "Ted Fisher"
        Me.Cntrl3.RowSource = "Ted_Fisher_Rep_Names"
        
End Select
End Sub

I'm not sure if it matters but the combobox is on a multipage control on the userform.

Any help would be greatly appreciated, as this is my first post I may have missed some important details. Let me know if you need more info.

Thanks
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
I'm my own worst enemy sometimes. I am an idiot, I had the code referencing the wrong Cntrl. I'm good
 
Upvote 0

Forum statistics

Threads
1,214,588
Messages
6,120,409
Members
448,959
Latest member
camelliaCase

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top