+ Reply to Thread
Results 1 to 3 of 3

Calculating in Userform

  1. #1
    Registered User
    Join Date
    04-03-2012
    Location
    Hallettsville Texas USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Calculating in Userform

    Hello everyone,

    Am looking for a solution to the following problem in Excel VBA.
    How can I program cq code the following formula and assign that code to a commandbutton (Calculate) on a userform ?

    The formula is 1/SQRT(24)*10

    (24) is a value from a combobox (Scale) on the same userform and 10 is a value from a textbox (Ship speed) on that userform.
    I would like to have the result of the calculation shown in yet another textbox (Model ship speed) on that userform.
    2,04 is the correct answer but I can't get it in that textbox through programming.
    Any suggestions are more than welcome as it has me flabbergasted.

    Thanks in advance,
    Dirk Smit

    [ATTACH]userform.jpg[/ATTACH]
    Attached Images Attached Images

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Calculating in Userform

    Try this, changing the control names as required.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    04-03-2012
    Location
    Hallettsville Texas USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Calculating in Userform

    @Norie,

    Thanks for the swift reply. It worked like a treat. And thanks also for adding the Round function.

    Best regards, Dirk

+ 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. Calculating/adding userform textbox values based on combobox selection and display to cell
    By SpreadsheetGirl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-04-2015, 08:57 AM
  2. [SOLVED] ListBox Userform (Sum, total and calculating)
    By calvinle in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-07-2014, 07:17 PM
  3. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-04-2014, 07:11 AM
  4. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-03-2014, 12:28 PM
  5. [SOLVED] Calculating different Textbox to another Textbox with in the userform
    By Shacker in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-27-2013, 11:46 PM
  6. [SOLVED] Calculating Time in Userform Textbox and Filtering Comboboxes Coding Help
    By hiddenupnorth in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-01-2012, 01:12 PM
  7. userForm as popup message while calculating
    By gtmeloney in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-02-2011, 11:28 AM

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