Results 1 to 2 of 2

Thread: Data Validation for all ActiveX Text Boxes

  1. #1

    Data Validation for all ActiveX Text Boxes



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I want to add simple data validation (numbers only) to many (10+) ActiveX text boxes. I know I can call a Sub for each TextBox_Change() event, but I need to know if I can create a function that activates when any text box is changed without asking each box to call the function. Does anyone know how to do this? Thanks in advance.

    - Rob

  2. #2
    Conjurer snb's Avatar
    Join Date
    May 2013
    Posts
    376
    Articles
    0
    Excel Version
    2020
    Yes: use comboboxes insted.

Tags for this Thread

Posting Permissions

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