+ Reply to Thread
Results 1 to 2 of 2

VBA userform validation - multiple textboxes must sum to the value in another textbox

  1. #1
    Registered User
    Join Date
    02-17-2015
    Location
    York, England
    MS-Off Ver
    2010
    Posts
    1

    Exclamation VBA userform validation - multiple textboxes must sum to the value in another textbox

    I am trying to add some validation to my userform.

    Users are asked to provide a whole number, and then this number is then broken down into different categories.

    I want to add some validation in to ensure the sum of the categories adds up to the whole number which is initially entered. Does anyone know how to do this?

    Please help!

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: VBA userform validation - multiple textboxes must sum to the value in another textbox

    This is easy, but it depends on your implementation, please attach your workbook

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

+ 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. One TextBox containing the chosen results of multiple TextBoxes
    By BandStand in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-26-2012, 01:53 PM
  2. Data validation in TextBox on UserForm
    By tim_chisman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2010, 09:33 AM
  3. Data Validation for all TextBoxes and Comboboxes in Userform
    By singhabhijitkumar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-12-2010, 05:48 PM
  4. Formatting Multiple Userform Textboxes
    By badeye in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-01-2010, 09:14 AM
  5. Change Textbox Backcolor (multiple textboxes)
    By msommerf in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2010, 10:52 AM

Tags for this Thread

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