LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,696
Default Data Validation Input Message Box Position Frozen

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation - input message yshridhar Excel Discussion (Misc queries) 0 January 28th 08 05:22 AM
Data Validation Input Message Klee Excel Discussion (Misc queries) 12 May 6th 07 01:24 PM
Data Validation Input Message Sandy Excel Worksheet Functions 1 March 8th 06 03:19 PM
DataValidationInput message irresistible007 Excel Worksheet Functions 1 December 3rd 05 01:06 PM
Data Validation - Location of input message box supergoat Excel Discussion (Misc queries) 5 April 25th 05 04:21 PM


All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"