Results 1 to 11 of 11

Data from Input Box overrides cell input validation

Threaded View

  1. #1
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Smile Data from Input Box overrides cell input validation

    I have two cells on a worksheet whith a custom validation for cell "M13" permitting Istext only and for cell "H17" permitting Isnumber only. To make it easier for the user, I have created an Input Box, but regardless of what is entered in this box the cell/s accept/s and ignore/s any validation.

    I found some code in the 'On-Screen Help' to Add or Modify xlValidationCustom etc., but it does not work, no matter how hard I try to tweak and twist.

    Could someone please help me with the correct code to maintain validations for the respective cells via the Input Box, to include an error message "You must enter a number" or "Text only is allowed, and no numbers"?

    If it is of any help, I am still working with Office2000.

    Thanks Guys!
    Last edited by Winon; 05-20-2007 at 12:04 AM. Reason: Wrong cell references in original post might create confusion

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1