Turn on the macro recorder and do it manually as I provided. then turn off
the macro recorder and see what is recorded.

--
Regards,
Tom Ogilvy


"itarnak" wrote in
message ...

In VBA of course....


i have 5 values in cells (a column), i want to make a macro which put
these 5 values , each on a line, in the inputmessage validation popup.
My Validation properties is created dynamicaly.

A macro is executed to do that at workbook load time.

iTarnak


--
itarnak
------------------------------------------------------------------------
itarnak's Profile:
http://www.excelforum.com/member.php...o&userid=27865
View this thread: http://www.excelforum.com/showthread...hreadid=475396