Show list of options basrd on drop down selection

[Frank Bacchus]

Hi:

I have a drop-down list in with "Completed", "Stalled" and "Closed". Based on the selection, I would like to have another drop-down list to appear (for "Stalled") and the user selects an entry. For "In Progress", I would list an Input Question "For How Long is this "In Progress" and an Input number (representing days) for the user to input. See attachment for example.

How can I accomplish this with a VB script. Thanks.

frank

 

[PCosta87]

Hi,

If it must be a VBA based solution, perhaps consider changing the thread to the appropriate section...

In any case, attached is a non VBA solution using INDIRECT as the data validation list.

Hope this helps.

 

[Frank Bacchus]

Hi PCosta:

Thanks. A non-VBA solution is fine. Where is the non VBA solution (code) so I can understand and change as needed.

thanks

frank

 

[PCosta87]

Hi,

non VBA means no code... it was done using named ranges and functions (specifically the INDIRECT function in the validation).

 

[Frank Bacchus]

Hi,

non VBA means no code... it was done using named ranges and functions (specifically the INDIRECT function in the validation).

thanks - cool

 

[PCosta87]

You are welcome