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.
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 = ""