+ Reply to Thread
Results 1 to 6 of 6

User form runs one calculation before a second?

  1. #1
    Forum Contributor
    Join Date
    04-20-2017
    Location
    Iowa
    MS-Off Ver
    2007
    Posts
    212

    User form runs one calculation before a second?

    Hello once again,
    This time I have a user form to run some calculations that needs a little help. I think the problem is that the first two lines need to run and produce a value before the third can function correctly. Without the third line, the calculations run as they should. So somehow there needs to be a stop in there before running that last command.

    Ideas?

    Thank you
    HTML Code: 

  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: User form runs one calculation before a second?

    What problems are you having with the third calculation?

    As far as I can see the calculations will be performed in the order you code them.

    How/when are you calling the posted sub and how/when are the textboxes involved in the calculations being populated?
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    04-20-2017
    Location
    Iowa
    MS-Off Ver
    2007
    Posts
    212

    Re: User form runs one calculation before a second?

    What happens is that nothing happens

    And after doing some quick debugging, even the first two aren't returning values, only the "deg" and """. Something else is going on here.

    I shall return!

  4. #4
    Forum Contributor
    Join Date
    04-20-2017
    Location
    Iowa
    MS-Off Ver
    2007
    Posts
    212

    Re: User form runs one calculation before a second?

    Okay, got the first two correct. I had changed the combo box named range without resetting its column count and bound column.

    Now I'm getting a run-time error; Type Mismatch. Not good with solving those.

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

    Re: User form runs one calculation before a second?

    Where are you getting that error?

  6. #6
    Forum Contributor
    Join Date
    04-20-2017
    Location
    Iowa
    MS-Off Ver
    2007
    Posts
    212

    Re: User form runs one calculation before a second?

    Norie thank you for the help. Turns out it was an issue with the formula, now I feel like a dumba....

+ 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] VBA code for Countifs calculation in user form
    By NikhilDixit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2017, 07:46 AM
  2. Help with VBA User-form. Spinbutton calculation
    By mcvideo in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-07-2016, 03:19 PM
  3. [SOLVED] Entering $ sign into a calculation on a user form
    By Nole68 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-20-2016, 07:03 PM
  4. [SOLVED] User Form texbox calculation to return % icon after value.
    By Colin Smit in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-04-2014, 06:24 PM
  5. [SOLVED] Calculation from Text Box Entries on User Form not working 100%
    By Colin Smit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-03-2014, 07:07 AM
  6. Calculation in User Form
    By mal.b.graham in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2011, 09:39 AM
  7. Problem displaying a calculation result in a user form
    By AndyRoo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2005, 05:50 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