+ Reply to Thread
Results 1 to 5 of 5

Adding text boxes in userform

  1. 10-21-2009, 12:43 AM #1
    jcarstens is offline
    Forum Contributor
    Join Date
    07-26-2007
    MS-Off Ver
    2007
    Posts
    102

    Adding text boxes in userform

    I have a user form where I would like the input of TextBox1 (+) plus the input of TextBox2 to show the sum in TextBox3.

    Any help would be greatly appreciated.

    Thank You.
    Reply With QuoteRegister To Reply
  2. 10-21-2009, 02:03 AM #2
    D_Rennie is offline
    Valued Forum Contributor
    Join Date
    05-14-2009
    Location
    gold coast
    MS-Off Ver
    Excel 2007
    Posts
    843

    Re: Adding text boxes in userform

    hello,
    Please try
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 10-21-2009, 03:02 AM #3
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Adding text boxes in userform

    A TextBox valu is by default a String. You need to convert the strings to a numerical value. You don't say how the calculation is triggered so I have used the exit event of the textboxes

    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
  4. 11-10-2009, 12:05 AM #4
    jcarstens is offline
    Forum Contributor
    Join Date
    07-26-2007
    MS-Off Ver
    2007
    Posts
    102

    Re: Adding text boxes in userform

    I have attached an example of what I am trying to accomplish. Any Help would be greatly appreciated.

    Thank You
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 11-10-2009, 02:23 AM #5
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,704

    Re: Adding text boxes in userform

    Would this do it?

    HTH

    John
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1