Catergory & Sub Catergoy

[harpscardiff]

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

[Duke Carey]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[harpscardiff]

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.