Switched from Combobox style Dropdowncombo to Dropdownlist "380" Error

Sirico

New Member
Joined
Sep 29, 2021
Messages
10
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
  2. Web
Hi everyone hope you're having a good friday.

I've recently switched my combolist styles on my user form, from Dropdowncombo to Dropdown list. This is causing a 380 error as it can't set the Text property due to it not being supported by the style I'm guessing.
This is where I think the culprit is, it is used it to input data on to the table I'm guessing I just need to change the .Text to ."something else" but I'm not sure what that is.
Thankyou for taking the time to look at the post.

VBA Code:
 ElseIf Me.CheckBox05k.Value = True Then
    
   

                                         ''''This has to match the number of rows input below
        .Cells(RowInsert, "A").Resize(1, 7).Value = Array( _
            Me.txtDate.Text, _
            Me.textboxparentsku.Text, _
            Me.comboboxbrand.Text, _
            Me.comboboxclosure.Text, _
            Me.comboboxgender.Text, _
            Me.comboboxmaterial.Text, _
            Me.comboboxmodel.Text _
        )
        ws.Range("H" & RowInsert).Value = CheckBox05k.Caption
        
        ElseIf Me.CheckBox05k.Value = False Then .Cells(RowInvert, "A").Resize(1, 8).Value = ""
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
When setting the Style property to fmStyleDropDownList, the value assigned to the Text or Value property must match one of the items listed in the combobox dropdown. Otherwise, as you've already seen, you'll get an error. And, I'm sure you would have noticed by now, the combobox will only allow you to manually choose one of the items from the dropdown list. It won't allow you to enter any other value.
 
Upvote 0
Solution
When setting the Style property to fmStyleDropDownList, the value assigned to the Text or Value property must match one of the items listed in the combobox dropdown. Otherwise, as you've already seen, you'll get an error. And, I'm sure you would have noticed by now, the combobox will only allow you to manually choose one of the items from the dropdown list. It won't allow you to enter any other value.
Thankyou it was the way I was doing my drobox content rather than doing rowsource I was populating using .Add item I changed it around and all seems well.
 
Upvote 0

Forum statistics

Threads
1,214,908
Messages
6,122,187
Members
449,071
Latest member
cdnMech

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