ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I assign button/buttons to XL 2007 by Macro for different (https://www.excelbanter.com/excel-worksheet-functions/223632-how-can-i-assign-button-buttons-xl-2007-macro-different.html)

Iraj

How can I assign button/buttons to XL 2007 by Macro for different
 
Hi :
I want to create a project report sheet format, using Macro to change the
names of projects and its addresses in the first rows to be changed when I
click the button.
E.G:
Project A with its address in merged cell A1:F1 changes when I click the
button A, on the cell M3.
Project B with its information changes in the same merged cell A1:F1 when I
click the button B on the cell M4.
And so on.
Is it possible with VBA or there is other way??

I appreciate any help in advance.


All times are GMT +1. The time now is 04:51 PM.

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