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

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?

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

Hi Eve,

This site will help you out

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

Regards,

Gav.


"Eve" wrote:

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?

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

Debra's dependent lists site would be better.

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


Gord Dibben MS Excel MVP

On Fri, 5 Oct 2007 04:55:02 -0700, Gav123
wrote:

Hi Eve,

This site will help you out

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

Regards,

Gav.


"Eve" wrote:

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?