PDA

View Full Version : Solved: userform



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

mdmackillop
10-28-2005, 02:33 AM
Hi Gautium,
Welcome to VBAX.
Here's a simple example
Regards
MD

gmahendru
10-28-2005, 02:37 AM
Thanks MD,

U r the best.

Gautam

mdmackillop
10-28-2005, 11:57 AM
Hi Gautium,
HTH, If you're happy with the answer than you can mark the thread solved using thread tools.
Regards
MD