Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My problem is how to link a form button to a cell and get that information
into a macro. I have written a small practice macro to perform some matrix multiplication assuming I have pre-selected the answer cells. Next I managed to get the macro to automatically use the cells below the current active cell for the answer array. Now, what I really want to do is apply this macro by selecting a button above each array. The button has now information on where it is in the sheet. I would like to lock it in a cell, and be able to reference the 4 cell below it as a range in my macro. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
terminate a runnig macro | Excel Programming | |||
Possible to assign macro defined as private to a form control. | Excel Programming | |||
help: master control macro and user form | Excel Programming | |||
Runnig a macro when excel opens | Excel Programming |