ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Anchor button to cell? (https://www.excelbanter.com/excel-programming/345946-anchor-button-cell.html)

Robert M. Gary[_2_]

Anchor button to cell?
 
Is it possible to create a button that lives in a cell? I think I want
to do this for two reasons...
1) So I can more easily align a column of buttons and
2) So they can reference a relative cell. So, each button would run the
same macro but compute based on the value of the cell to the left.

-Robert


MattShoreson[_54_]

Anchor button to cell?
 

if you use a button from the control toolbox instead of the forms menu
it will exhibit the behaviour you need.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=486218



All times are GMT +1. The time now is 06:44 PM.

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