How to use Drop down list to reflect a set of fields to be filled?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eve - 05 Oct 2007 10:15 GMT

I am making a form whereby the customer able to select what type of account
they would like to apply. For eg. there are windows and unix accounts.
Whenever user choose windows, there are bunch of necessary blanks pop up
below relating to windows and vice versa. Which function is the best to use?
Drop down list? Combo? and how?

Reply to this Message

Gav123 - 05 Oct 2007 12:55 GMT

Hi Eve,

This site will help you out

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

Regards,

Gav.

> I am making a form whereby the customer able to select what type of account
> they would like to apply. For eg. there are windows and unix accounts.
> Whenever user choose windows, there are bunch of necessary blanks pop up
> below relating to windows and vice versa. Which function is the best to use?
> Drop down list? Combo? and how?

Reply to this Message

Gord Dibben - 05 Oct 2007 21:39 GMT

Debra's dependent lists site would be better.

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

Gord Dibben MS Excel MVP

>Hi Eve,
>
[quoted text clipped - 11 lines]
>> below relating to windows and vice versa. Which function is the best to use?
>> Drop down list? Combo? and how?

Reply to this Message