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