LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 102
Default Remove Data validation Input messages

Thanks to all who read this, your time is important: I am stuck. I
have used DATA VALIDATION in several cells of my application. Several
of these cells use the INPUT MESSAGE of the DATA VALIDATION as a kind
of mini Help menu. I would like to be able to offer the user the
option of turning off ALL of these tips as they can become annoying
after a-while. I have tried the following approach:

(Only one cell here as an attempt to get it to work at all...)

InvoiceEntry.Range("C15").Validation.ShowInput=Fal se

It doesn't work. I have been through the object browser trying
to get the heirarchy straight and it seems to me I should be able to
do this, alas I cannot. If any of you MVP types out there, or anyone
else for that matter, have any suggestions, I would greatly appreciate
it.

To restate, I want to retain the Data Validation of the cell,
but remove the Input Message. Thanks again, Mark...
 
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 Input Validation Mark S[_2_] Excel Discussion (Misc queries) 5 February 24th 08 12:00 AM
Validation: - different messages for defined input values Karuna Excel Discussion (Misc queries) 2 December 24th 07 01:31 PM
Editing Data Validation Input Messages Shelley Excel Discussion (Misc queries) 0 August 17th 07 01:54 AM
Can validation input messages be locked in place? Chris Excel Discussion (Misc queries) 1 March 22nd 06 07:53 PM
Creating input messages or comments Louise Excel Worksheet Functions 4 January 19th 06 02:04 PM


All times are GMT +1. The time now is 11:33 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"