+ Reply to Thread
Results 1 to 2 of 2

validate data

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    validate data

    Hello to all,
    you can modify data validation in E3:E50
    if B3 is empty no validation in E3
    if B4 is emptY no validation in E4
    if B5 is empty no validation in E5
    etc..
    Alleged example.
    max_max ..
    Attached Files Attached Files

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: validate data

    Hi max_max

    Perhaps something like this in the Worksheet Module...
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Validate Data between two workbooks
    By kingsdime29x in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2017, 01:38 PM
  2. [SOLVED] How do I validate data and then summarize corresponding amounts that matches the data?
    By Chase1026 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-18-2014, 04:21 PM
  3. Data Validate by dd/mm/yyyy tt:tt (24 Hr)
    By ianflexie in forum Excel General
    Replies: 1
    Last Post: 05-20-2013, 11:24 AM
  4. How to validate whenever new data is entered
    By jrexcel1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2012, 03:43 PM
  5. Validate two fields when one field you need a formula to validate
    By cmwilbur in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-29-2010, 11:32 AM
  6. how to validate data in another worksheet
    By lalaexcel in forum Excel General
    Replies: 3
    Last Post: 02-18-2006, 05:11 AM
  7. Validate data
    By JT in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2005, 05:06 PM

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