ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Run procedure from worksheet change event (https://www.excelbanter.com/excel-programming/404476-run-procedure-worksheet-change-event.html)

ranswert

Run procedure from worksheet change event
 
How can I call a procedure in a VB module from a worksheet change event?

John Bundy

Run procedure from worksheet change event
 
Just call it, if its name is test() you can type
call test

or usually just
test

make sure it is accessible eg public if need be.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"ranswert" wrote:

How can I call a procedure in a VB module from a worksheet change event?



All times are GMT +1. The time now is 08:28 AM.

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