danovkos
09-20-2011, 05:33 AM
Hi,
pls. i try to handling with combobox and labels in userform. I try e.g. load list of values to combobox if any condition is true. Problem is, that i have to work with many of combobox (combobox1, combobox2, combobox3...) and also with many labels (label1, label2...)
I tried to set my combobox and labels with this macro, but it doesnt works.
For i = 1 To 6
produktik = "COMBO_produkt" & i
OPUcko = "COMBO_OPU" & i
CIFko = "Label_cif" & i
If CIFko.Value <> "" Then
produktik.list = Workbooks(PrehladyNAMEVp).Worksheets("Krieš").Range("BD2:BD31").Value
OPUcko.list = Workbooks(PrehladyNAMEVp).Worksheets("Krieš").Range("Q2:W103").Value
End If
Next i
COMBO_produkt is name of my combo in userform and Label_cif is name of my label in userform.
any suggestions?
thx a lot
pls. i try to handling with combobox and labels in userform. I try e.g. load list of values to combobox if any condition is true. Problem is, that i have to work with many of combobox (combobox1, combobox2, combobox3...) and also with many labels (label1, label2...)
I tried to set my combobox and labels with this macro, but it doesnt works.
For i = 1 To 6
produktik = "COMBO_produkt" & i
OPUcko = "COMBO_OPU" & i
CIFko = "Label_cif" & i
If CIFko.Value <> "" Then
produktik.list = Workbooks(PrehladyNAMEVp).Worksheets("Krieš").Range("BD2:BD31").Value
OPUcko.list = Workbooks(PrehladyNAMEVp).Worksheets("Krieš").Range("Q2:W103").Value
End If
Next i
COMBO_produkt is name of my combo in userform and Label_cif is name of my label in userform.
any suggestions?
thx a lot