dropdown lists

[szermat]

Hello,

I have a first drop down list with 4 possible selections. When a selection is made, I would like another dropdown list to appear with different values, depending on the initial selection.

Many thanks for your replies.
S.

[stevebriz]

Are these dropdown list boxes on a userform?

[stevebriz]

oops I see this is marked resolved now...Please disregard my last post

[eight8]

oops I see this is marked resolved now...Please disregard my last post

May i know what the solution to this problem? I was wondering whether is it possible to do in excel?

[stevebriz]

here is an example if you are using a userform with two comboboxes

Please Login or Register  to view this content.

[harishs]

Hi,
Can you help me out How to convert numbers to words.

eg: Cell1: 2120
Cell2: Two thousand one hundred and twenty.

Pls help me out in this.

[stevebriz]

This really should be in another thread.

To answer you question...you can look at this:

http://www.ozgrid.com/VBA/ValueToWords.htm

[eight8]

here is an example if you are using a userform with two comboboxes

Please Login or Register  to view this content.

Can this code be apply to dropdown list too coz i don't have any combobox in my worksheet?

[stevebriz]

Are you using a named range for the validation dropdown lists or are you just entering comma sperated values?

[eight8]

Are you using a named range for the validation dropdown lists or are you just entering comma sperated values?

named range

[stevebriz]

The macro in this Post is for comboboxes not dropdown through data validation. Cascading Dropdowns can be done...but it takes a bit more coding.

[eight8]

The macro in this Post is for comboboxes not dropdown through data validation. Cascading Dropdowns can be done...but it takes a bit more coding.

I see. Then it is okie. Thanks for your kind help.