+ Reply to Thread
Results 1 to 3 of 3

Multiply range of cells by a value with Command button

  1. #1
    Registered User
    Join Date
    07-06-2015
    Location
    Iowa
    MS-Off Ver
    2013
    Posts
    15

    Multiply range of cells by a value with Command button

    This one seems pretty easy but i cannot figure it out.

    I want to be able to click a command button to show net profit (cell values mulitplied by .7) then when I click a gross profit button it will return to the original values.

    Thanks!

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Multiply range of cells by a value with Command button

    Hi mcanfield,

    You need to provide more context/information here... what cells get multiplied, where does the value go? Maybe you can upload a workbook with the same structure as the real one?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Forum Contributor
    Join Date
    04-20-2015
    Location
    Switzerland
    MS-Off Ver
    2010
    Posts
    312

    Re: Multiply range of cells by a value with Command button

    Please don't open multiple threads with basically the same Question.
    We provided you a solution here already

    command-button-to-multiple-cells-by-value

    Simply put the code for Mouseup to the 2nd button

+ 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. Clear the Specific Range of Cells Using a Command Button
    By Abinaya in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-02-2014, 05:50 AM
  2. how to make command button insert picture in range of cells
    By sspreyer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2013, 01:51 AM
  3. Command button to request user input (selection) of a range of cells
    By KarlGramith in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2013, 05:37 PM
  4. Replies: 1
    Last Post: 09-17-2007, 09:57 PM
  5. command button that puts specific numbers in a range of cells
    By ko6ad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2006, 01:41 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