gmahendru
10-28-2005, 02:06 AM
Hi people...
I am new to VBA so wants some help.
I created one userform where i am selecting engine type from the list... I did that perfectly ...
I used this code
For Each cGenset In wksdatabase.Range("Genset")
With Me.cboGenset
.AddItem cGenset.Value
.List(.ListCount - 1, 1) = cGenset.Offset(0, 1).Value
End With
Next cGenset
I am trying now that next combo box should give me the subtypes of only the selected genset from the list. How to do that???
Kinldy help
Thanks in advance
Gautam
I am new to VBA so wants some help.
I created one userform where i am selecting engine type from the list... I did that perfectly ...
I used this code
For Each cGenset In wksdatabase.Range("Genset")
With Me.cboGenset
.AddItem cGenset.Value
.List(.ListCount - 1, 1) = cGenset.Offset(0, 1).Value
End With
Next cGenset
I am trying now that next combo box should give me the subtypes of only the selected genset from the list. How to do that???
Kinldy help
Thanks in advance
Gautam