Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have data validated cells in my worksheet. The input message appears in the
same place on the screen no matter which cell you are in. Can you set the message box to appear always to the left, right, above or below your data validated cell? When you use your mouse to scroll down the input message box stays exactly in the same spot on the screen. Thanks, |
#2
![]() |
|||
|
|||
![]()
Hi Bernina,
I do not think that the position of the data validation message can be controlled You may, however, wish to look at Debra Dalgleish's download files at: http://www.contextures.com/excelfiles.html The Data Validation files include an 'Input Message in Textbox' file which demonstrates the use of a textbox to display an input message. The size, position and formatting of the textbox can be controlled. --- Regards, Norman "Bernina27" wrote in message ... I have data validated cells in my worksheet. The input message appears in the same place on the screen no matter which cell you are in. Can you set the message box to appear always to the left, right, above or below your data validated cell? When you use your mouse to scroll down the input message box stays exactly in the same spot on the screen. Thanks, |
#3
![]() |
|||
|
|||
![]()
Normally, the input message will appear near the bottom right of the
active cell. However, if you move one of the messages, all messages will appear in the same spot. If you close, then reopen the workbook, the messages should go back to their original positions. Bernina27 wrote: I have data validated cells in my worksheet. The input message appears in the same place on the screen no matter which cell you are in. Can you set the message box to appear always to the left, right, above or below your data validated cell? When you use your mouse to scroll down the input message box stays exactly in the same spot on the screen. Thanks, -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
API for MS Chart Control | Charts and Charting in Excel | |||
Check box and and formula | Excel Discussion (Misc queries) | |||
Getting an error message "Cannot shift objects off of sheet" | Excel Discussion (Misc queries) | |||
Control Tab from Combo box- format control missing!! | Excel Discussion (Misc queries) | |||
Copying list-box control | Excel Discussion (Misc queries) |