Validation inputmessage multilines
 

hi,

i want to make a kind of list like that :
1. first
2. Second
3. Third


in the inputmessage off the Validation object.

But how to tell excel to go on the next line for each line?
For the moment it does that: "1. first 2. Second 3. Third" ..ugly..


That's not a cell ...remember...just a popup , so don't speak abou
cells properties :-)


iTarna

--
itarna
-----------------------------------------------------------------------
itarnak's Profile: http://www.excelforum.com/member.php...fo&userid=2786
View this thread: http://www.excelforum.com/showthread.php?threadid=47539

Validation inputmessage multilines
 

first line Alt+enter
second line Alt+enter
third line

worked for me.

--
Regards,
Tom Ogilvy


"itarnak" wrote in
message ...

hi,

i want to make a kind of list like that :
1. first
2. Second
3. Third


in the inputmessage off the Validation object.

But how to tell excel to go on the next line for each line?
For the moment it does that: "1. first 2. Second 3. Third" ..ugly..


That's not a cell ...remember...just a popup , so don't speak about
cells properties :-)


iTarnak


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

Validation inputmessage multilines
 

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

Validation inputmessage multilines
 

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