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.
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.
Last edited by szermat; 05-08-2007 at 07:54 AM.
Are these dropdown list boxes on a userform?
VBA - The Power Behind the Grid
Posting a sample of your workbook makes it easier to look at the Issue.
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?Originally Posted by stevebriz
here is an example if you are using a userform with two comboboxes
![]()
Please Login or Register to view this content.
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.
This really should be in another thread.
To answer you question...you can look at this:
http://www.ozgrid.com/VBA/ValueToWords.htm
Can this code be apply to dropdown list too coz i don't have any combobox in my worksheet?Originally Posted by stevebriz
Are you using a named range for the validation dropdown lists or are you just entering comma sperated values?
named rangeOriginally Posted by 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.
I see. Then it is okie. Thanks for your kind help.Originally Posted by stevebriz
![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks