+ Reply to Thread
Results 1 to 2 of 2

VBA UserForm Text Fields

  1. #1
    Registered User
    Join Date
    02-14-2019
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5

    VBA UserForm Text Fields

    I am trying to make the totals column equal the last value entered. So if only the contract is filled in it will display that, if CO #1 is filled in, it displays that value only etc. I dont want it to add the values. Form.JPG

  2. #2
    Forum Contributor
    Join Date
    10-02-2012
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    257

    Re: VBA UserForm Text Fields

    I don't know your control names but a simple 4x loop is all you need.

    Please Login or Register  to view this content.
    You'd need to adapt the code to your naming and number scheme but that should work.

+ 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] Import data from fields in one sheet to UserForm text boxes
    By sharonca in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-01-2022, 01:31 PM
  2. VBA Multipage Userform.: transfer textbox fields from a multipage userform to a cell
    By TheGiantJudge in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-31-2019, 01:26 PM
  3. [SOLVED] Userform inputs comparison with sheet cells and if true reset userform fields
    By aidan5800 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-08-2018, 04:51 PM
  4. Passing Text into Userform Fields
    By excelenergy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2013, 02:16 PM
  5. Combining text from separate userform fields
    By nohero in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2011, 10:36 AM
  6. Changing numbes in text fields into numbers in number fields
    By freaksareus in forum Excel General
    Replies: 4
    Last Post: 10-23-2008, 05:47 AM
  7. Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS!
    By PSSSD in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2006, 04:35 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