ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Assign a Macro (https://www.excelbanter.com/excel-discussion-misc-queries/64301-assign-macro.html)

Pendelfin

Assign a Macro
 
How can I assign a macro to a specific cell in an Excel sreadsheet. I know
theres a way but I cant find the answer. Many thanks for your help.

Chip Pearson

Assign a Macro
 
There is no way to assign a macro to a cell. However, you can use
either the Change or SelectionChange event procedure to execute
code with a cell is changed or selected, respectively.

See http://www.cpearson.com/excel/events.htm for info.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"Pendelfin" wrote in
message
...
How can I assign a macro to a specific cell in an Excel
sreadsheet. I know
theres a way but I cant find the answer. Many thanks for your
help.





All times are GMT +1. The time now is 01:47 AM.

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