Synchronized combo box in excel form

[sunilkes]

How can I make a synchronized combo box in an excel userform?

I need to limit the choices in Combo2 depending on what has been
chosen on Combo1.

Thanks in advance for any help.

Cheers
Sunil

 

[Toppers]

Perhaps as an alternative:

http://www.contextures.com/xlDataVal13.html

 

[sunilkes]

Thanks that is a good alternative, but i am looking at a VB form
specifically..