Catergory & Sub Catergoy

[harpscardiff]

Hi There,

I'm creating a form, I want to be a able to select a catergory in on
txtbox and based on a catergory another txt box has differen
options.

for example:

catergory selected hardware

sub catergory, in the form of a drop down: PC Base Unit, monitor
keybaord, mouse, printer.

i'm struggling to do this - any ehlpw ould be much apprecited.

Thanks:cool

 

[Guest]

See Debra Dalgliesh's Data Validation basics at this link. Includes
instructions on how to accomplish your task

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

 

[Guest]

Hi

Have a look here for some help:
http://www.contextures.com/xlDataVal02.html

Andy.

"harpscardiff" <[email protected]>
wrote in message
news:[email protected]...

 

[harpscardiff]

thanks for that guys,

I was aware how to do it in excel, but i'm not sure how to code it vi
VBA....any ideas?

Thanks again