+ Reply to Thread
Results 1 to 8 of 8

I need a Macro to Add two numbers with excel input form

  1. #1
    Registered User
    Join Date
    05-04-2015
    Location
    Zambia
    MS-Off Ver
    2013
    Posts
    8

    Smile I need a Macro to Add two numbers with excel input form

    I am new to this forum,
    I need help coming up with this macroUsing Macros in Excel 2013)
    a Macro that do the following
    • Allows a user to enter 2 numbers using data input forms (the 2 values are save on the spreadsheet)
    • Then adds the two numbers (answer is displayed on the spreadsheet)
    • Then asks if the user would like to enter more numbers to be calculated
    o If a user agree then allows the user to enter 2 more numbers for the calculation to take place
    o Otherwise exit Macro

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: I need a Macro to Add two numbers with excel input form

    Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

    We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

    If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

  3. #3
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: I need a Macro to Add two numbers with excel input form

    Something like:
    Please Login or Register  to view this content.
    Gary's Student

  4. #4
    Valued Forum Contributor
    Join Date
    08-22-2011
    Location
    Auckland
    MS-Off Ver
    Excel 2019
    Posts
    716

    Re: I need a Macro to Add two numbers with excel input form

    Well said teylyn..
    Although with me being me, if this facility was available when I was at school, I would look for the easy way out too

  5. #5
    Registered User
    Join Date
    05-04-2015
    Location
    Zambia
    MS-Off Ver
    2013
    Posts
    8

    Re: I need a Macro to Add two numbers with excel input form

    Thanks Jakobshavn, I am completely new to macros in excel, have been reading some basics. This will help.
    This code should be under a command button, right?
    Thanks again

  6. #6
    Registered User
    Join Date
    05-04-2015
    Location
    Zambia
    MS-Off Ver
    2013
    Posts
    8

    Re: I need a Macro to Add two numbers with excel input form

    Thanks for the advise, I am learning some basic on Macros in Excel, I have done recording macro, now I am looking at writing some code too. Its not necessarily Homework, but an Exercise.
    Thanks again

  7. #7
    Registered User
    Join Date
    05-04-2015
    Location
    Zambia
    MS-Off Ver
    2013
    Posts
    8

    Re: I need a Macro to Add two numbers with excel input form

    I have tried this macro, thanks its looking good. I however, would like to use input form(UserForm), And also when user is prompted whether he wants to do this again( answer = Application.InputBox(Prompt:="Do you want to do this again??", Type:=2) How do I modify this code so that, I include yes/no options clickable by user before going to next step...
    Thank you

  8. #8
    Registered User
    Join Date
    05-07-2015
    Location
    lusaka zambia
    MS-Off Ver
    2007
    Posts
    1

    Re: I need a Macro to Add two numbers with excel input form

    What is a maro calulator

+ 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. i want to have a macro code change based on input from a textbox in a form
    By Jenkins27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2015, 07:24 PM
  2. How to create input form using a macro
    By jsmith88 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-14-2014, 06:14 AM
  3. Macro to transfer data from Input sheet to summary form
    By CA_needing_help in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-04-2013, 03:14 AM
  4. Macro to move data from an input form to a datalog worksheet
    By wstring in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-02-2013, 12:28 PM
  5. Recording a macro to copy from an Input Form
    By TCS111 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-23-2013, 05:12 AM

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