+ Reply to Thread
Results 1 to 2 of 2

(VBA User form)Can i do data validation within TextBox Properties Window

  1. #1
    Registered User
    Join Date
    05-09-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    56

    (VBA User form)Can i do data validation within TextBox Properties Window

    Hello,

    I'm in the process of creating a user form. I usually set validations such as Combobox1 should only havee 7 numerics kinda validation to my Submit button. But i was wondering if there is a way to do this at the Textbox Properties windown.


    Thanks,

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: (VBA User form)Can i do data validation within TextBox Properties Window

    There's only one property you could use for data validation, MaxLen, and all that does is set the maximum length of what's entered in the textbox.
    If posting code please use code tags, see here.

+ 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] user form to input data according to text in textbox and listbox
    By a.hudrea in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-10-2014, 04:27 AM
  2. Edit Sheet1 data by using User Form Textbox
    By lapot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2012, 04:27 AM
  3. Property window does not display the properties of the form
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-21-2012, 06:03 AM
  4. how to add user defined properties to a textbox?
    By jayzee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2010, 03:22 AM
  5. User Form Data Validation
    By MBlake in forum Excel General
    Replies: 2
    Last Post: 04-18-2005, 04: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