Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
See what happens when I overthink things... :-) Thank you for the reply!
"MM Phil" wrote: Actually, I finally found a thread here from 2005 that was asking the opposite: someone wanted the text box to stay in one position, and it wouldn't. It turns out that if the message box gets moved, all the data validation text boxes are moved to that position UNTIL THE SHEET IS SAVED, CLOSED, THEN REOPENED. At that point, the text message boxes appear as normal, and appear next to the cell in question. Anyway, thanks for answering so quickly, Sean. -- Phil Grimes Plant Engineer Doumak, Inc. "Sean Timmons" wrote: Sounds like maybe the best thing to do at this point is highlight the entire sheet, go to your validation and click the Clear All button, then re-do the validation where it's needed... "MM Phil" wrote: I am using Data Validation as a type of "Cell Tip" information box. For instance, if I choose a particular cell, the message box will say "Load 1 - Number of cases or units shipped". This is to tell the person to input that requested information into the box. This worked fine until I inadvertently dragged a box from its position next to the cell to somewhere else on the screen. Now, EVERY Data Validation message box appears at the same place on the screen; it no longer appears near the chosen cell, as before. Is there a way to "Undo" this? -- Phil Grimes Plant Engineer Doumak, Inc. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation - input message | Excel Discussion (Misc queries) | |||
Data Validation Input Message | Excel Discussion (Misc queries) | |||
Data Validation Input Message | Excel Worksheet Functions | |||
DataValidationInput message | Excel Worksheet Functions | |||
Data Validation - Location of input message box | Excel Discussion (Misc queries) |