Hi,
i've 2 drop down or list box.
when user select a value in drop down box 1, the values will change in drop
down box 2.
eg. value in box 1: account, sales
value appear in box 2 for user to select[when "account" is selected in box
1]: salary, P&L,...
value appear in box 2 for user to select[when "sales" is selected in box 1]:
quotation, invoice,....

regards

See Debra Dalgleish's site:

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

--
Regards,
Tom Ogilvy

"Vincent" wrote in message
...
Hi,
i've 2 drop down or list box.
when user select a value in drop down box 1, the values will change in
drop
down box 2.
eg. value in box 1: account, sales
value appear in box 2 for user to select[when "account" is selected in box
1]: salary, P&L,...
value appear in box 2 for user to select[when "sales" is selected in box
1]:
quotation, invoice,....

regards