How to create pick list in VBA
 

I want to create a pick list that can be opened by right clicking on
any cell in a worksheet.

Data-Validation will not work because the pick list range is in a
different worksheet.

How can I do this?

John W.

How to create pick list in VBA
 

insert =Name=Define

Name: PickList
Refersto: =Sheet2!$A$1:$A$20

then in Data =Validation,
Select list

in the source textbox use

=PickList

Include the "=" sign.

--
Regards,
Tom Ogilvy

"John" wrote in message
oups.com...
I want to create a pick list that can be opened by right clicking on
any cell in a worksheet.

Data-Validation will not work because the pick list range is in a
different worksheet.

How can I do this?

John W.