vba code for validation

[Guest]

i have a range of cells in sheet1 that i need have validation from a list in
sheet2.
what vba code could i write to have a drop down list?

 

[Tom Ogilvy]

Turn on the macro recorder and do it manually. See what code you get. That
will be a start and will be directly applicable to you situation.

 

[Tim Williams]

Name the range in sheet 2

in sheet1 select the cells and then select data>>validation>>"allow"--list

in the "source" textbox type
=yourRangeName

Tim.