Why do codes A & B below give me an Object Required (424) error (A is assigned to a button, B obviously fires on WB open) but C works without any issues?:
ComboBox1.Value = ""
ComboBox2.Value = ""
Private Sub Workbook_Open()
Dim ROWC As Integer
ROWC = Worksheets("JOB...
Is it possible to populate datas inside cells(starts from K2) instead of listbox with the given sample below code?
Private Sub CommandButton1_Click()
Dim r As Long, Ac As Long, c As Long
If ComboBox1.Value <> -1 And ComboBox2.Value <> -1 Then
I try to create a userform using Comboboxes, here the value of Box3 depends on the choice made in Box2. My code does not work. Someone a solution? Kind regards
ComboBox1.List= Array("BIO", "LAN", "MAT", "Prodem")
ComboBox2.List = Array("klimaat","stoten")