+ Reply to Thread
Results 1 to 7 of 7

Userform calculator only performing the last 2 buttons clicked.

  1. #1
    Forum Contributor
    Join Date
    07-01-2010
    Location
    Niles, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    137

    Userform calculator only performing the last 2 buttons clicked.

    I have found a code on a site that allows me to make a userform calculator. It works fine except that it won't add, subtract, multiply or divide more than 2 numbers. meaning if I enter in 2 + 2 and hit the equals button it gives me 4. But if I hit 2 + 2 + 4 it gives me 6 instead of 8. Below is the code I found and am using and this one is in module4

    Please Login or Register  to view this content.
    and here is the code that's on the userform.
    Please Login or Register  to view this content.
    Could someone please help me out with getting this to do more than just the last 2 numbers

    Thanks in advance

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,840

    Re: Userform calculator only performing the last 2 buttons clicked.

    Please Post the workbook.
    Last edited by mehmetcik; 02-17-2016 at 12:57 PM.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Forum Contributor
    Join Date
    07-01-2010
    Location
    Niles, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    137

    Re: Userform calculator only performing the last 2 buttons clicked.

    Great thank you!

  4. #4
    Forum Contributor
    Join Date
    07-01-2010
    Location
    Niles, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    137

    Re: Userform calculator only performing the last 2 buttons clicked.

    Well I managed to upload it somehow but I can't seem to attach it to this.
    Attached Files Attached Files

  5. #5
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,840

    Re: Userform calculator only performing the last 2 buttons clicked.

    Userform does not load.

    What exactly did you want it to do and where did you get it from.

  6. #6
    Forum Contributor
    Join Date
    07-01-2010
    Location
    Niles, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    137

    Re: Userform calculator only performing the last 2 buttons clicked.

    Well I had to take my workbook apart to get that. But it loads when I click on a sheet. So I have it set at
    Please Login or Register  to view this content.
    But what I want it to do is to be able to calculate more. Right now it only adds, subtracts, multiply or divides with the last 2 numbers pressed. So if wanted to add 3 + 3 + 8 i would like it to show me the answer of 14 when I hit equals. But it will only show me 11 because those were the last 2 numbers I pressed.

  7. #7
    Forum Contributor
    Join Date
    07-01-2010
    Location
    Niles, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    137

    Re: Userform calculator only performing the last 2 buttons clicked.

    I don't want it to put the end value anywhere. Just want to be able to use this calculator on the screen in place of using the one next to my desk. This workbook will be used by many so I'm attempting to make it easier by having this already on the screen.

+ 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] Userform - If clicked anywhere
    By sur4j in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2014, 04:42 PM
  2. Macros to record data for different buttons that are clicked
    By LoKathrynMac in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2014, 04:38 PM
  3. How to Develop a Break Time Calculator with Buttons
    By vrindamithul in forum Excel General
    Replies: 0
    Last Post: 02-10-2013, 07:32 AM
  4. [SOLVED] Disabling an Entire Frame with Option Buttons if other Option Buttons are not clicked.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-20-2012, 04:07 AM
  5. Captions of CommandButtons disappear after buttons are clicked
    By elfsprin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-15-2011, 02:45 PM
  6. Option Buttons Resizing When Clicked
    By agentsmith83 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-15-2010, 04:04 PM
  7. Why Userform Buttons Don't Match System Buttons?
    By msleger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2008, 12:43 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