Results 1 to 2 of 2

Userform text box to a cell but with the result value of IF statement

Threaded View

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    USA
    MS-Off Ver
    Offic 2010
    Posts
    2

    Userform text box to a cell but with the result value of IF statement

    Hi
    I am trying to create a production userform, there are many fields to add and some have calculations.

    I would like to add the values, but with and IF Statement that if the sum is greater than a 100 multiply it by .000453592

    .Cells(lRow, 5).Value = Val(Me.trai7.Text) + Val(Me.trai8.Text) + Val(Me.trai9.Text)
    I am new creating userforms and I have no idea how to to IF statements in this kind of situation

    thanks
    Last edited by vlady; 05-06-2013 at 08:25 PM.

Thread Information

Users Browsing this Thread

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

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