Results 1 to 4 of 4

data validadion doesn't work when worksheet is populated from userfrom??????

Threaded View

ciapul12 data validadion doesn't work... 02-21-2014, 04:44 PM
ciapul12 Re: data validadion doesn't... 02-22-2014, 03:28 PM
p24leclerc Re: data validadion doesn't... 02-22-2014, 03:32 PM
ciapul12 Re: data validadion doesn't... 02-22-2014, 03:53 PM
  1. #1
    Forum Contributor
    Join Date
    08-29-2011
    Location
    Wisbech England
    MS-Off Ver
    Excel 2010
    Posts
    308

    data validadion doesn't work when worksheet is populated from userfrom??????

    Hi All
    I have this formula =COUNTA($A:$A)<=4 that limits amount of cells that can be populated in column A, I use data validation with "Allow costume" option and using that formula.
    It works fine from worksheet it displays the message when the limit is reached but it doesn't work when data is inputed/populated from userfrom, it allows userform to put more entries than set limit 4 in this case.
    Is this common issue? has anyone ever come accross something like this?

    Thank You.
    Dan
    Last edited by ciapul12; 02-21-2014 at 09:12 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] data validation to limit amount of cell being populated in column A
    By ciapul12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2014, 10:14 PM
  2. data validation to limit amount of cell being populated in column A
    By ciapul12 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2014, 10:14 PM
  3. Data Validation Combo Box - Indirect Function/Limit to one column
    By AlliG in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-13-2013, 07:48 PM
  4. Need to know if their is a way to limit the amount of data that is in a column
    By sxblackmon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-24-2012, 04:16 PM
  5. Replies: 9
    Last Post: 06-08-2012, 06:22 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