| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
| Validation (Drop down list vs simple text length validation) | Excel Programming | |||
| Validation (Drop down list vs simple text length validation) | Excel Programming | |||
| Validation (Drop down list vs simple text length validation) | Excel Programming | |||
| Writing multilines to a text file without closing | Excel Programming | |||
![itarnak[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
