Hi There,

I'm creating a form, I want to be a able to select a catergory in one
txtbox and based on a catergory another txt box has different
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


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=517311

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

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


"harpscardiff" wrote:


Hi There,

I'm creating a form, I want to be a able to select a catergory in one
txtbox and based on a catergory another txt box has different
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


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=517311

Hi

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

Andy.

"harpscardiff"
wrote in message
news:harpscardiff.23y1sm_1141137601.3008@excelforu m-nospam.com...

Hi There,

I'm creating a form, I want to be a able to select a catergory in one
txtbox and based on a catergory another txt box has different
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


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile:
http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=517311

thanks for that guys,

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

Thanks again.


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=517311