Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris
 
Posts: n/a
Default Can validation input messages be locked in place?

I have cells that require validation. I've added input messages to clarify
the impact of the selections. The problem I'm having is that I would like
the input message to stay in its location if the user of my spreadsheet
chooses to keep the input message box open. When you scroll down the input
message stays on the screen even if you scroll to the very end. Very
annoying. Is there a way to keep it in a fixed location easily? For now it
looks like I will have to write some code...
  #2   Report Post  
Posted to microsoft.public.excel.misc
~RobW
 
Posts: n/a
Default Can validation input messages be locked in place?

That is a great question, and as far as my research has taken me, the answer
is no. It doesn't seem that there is any way to get the box to stay put. I
agree with your solution to write custom code; while it can be time
consuming, though, the benefits of custom code can be great, as I'm sure you
know. If I find out anything contrary to what I understand based on
documentation and MSDN, I will certainly let you know.

~murob2



"Chris" wrote in message
...
I have cells that require validation. I've added input messages to clarify
the impact of the selections. The problem I'm having is that I would like
the input message to stay in its location if the user of my spreadsheet
chooses to keep the input message box open. When you scroll down the
input
message stays on the screen even if you scroll to the very end. Very
annoying. Is there a way to keep it in a fixed location easily? For now
it
looks like I will have to write some code...


Reply
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 locatioin has become static spence Excel Worksheet Functions 2 March 19th 06 09:34 PM
Creating input messages or comments Louise Excel Worksheet Functions 4 January 19th 06 02:04 PM
Validation Box all in same places kayabob Excel Discussion (Misc queries) 2 June 15th 05 03:27 PM
Comments using Validation input Don Cameron Excel Discussion (Misc queries) 2 March 29th 05 09:21 PM
excel validation to 1 decimal place Tracy New Users to Excel 4 February 23rd 05 11:09 PM


All times are GMT +1. The time now is 07:20 AM.

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

About Us

"It's about Microsoft Excel"