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.

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" <j.wirt.201@gmail.com> wrote in message
news:1145128028.817156.183150@u72g2000cwu.googlegroups.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.
>