ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Inserting buttons that perform mathematic operations (https://www.excelbanter.com/excel-discussion-misc-queries/245526-inserting-buttons-perform-mathematic-operations.html)

MichaelZ

Inserting buttons that perform mathematic operations
 
I have a matrix of numbers:

a1 b1 c1 d1
a2 b2 c2 d2
a3 b3 c3 d3

I'd like to divide each of the values in this matrix by a particular number
that the user selects, then have the new values in a separate matrix nearby
the original one. One thing, I'd like the user to be able to select the
dividend by simply pressing a button that is specific to each dividend value.
As part of this, please show how to insert the buttons and link each to a
dividend value. Thanks.


All times are GMT +1. The time now is 06:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com