A question concerning CASE STUDY, pg. 122, VBA & Macros 2016

[Virgin]

How would I call the function in the case study?;

I tried the following:

"Worksheet_Change(Range("A1:A2"))"

Thank you...

 

[starl]

You don't call events. If you set up code in an event but you also want to use that code in another way, then you put the code in its own Sub and have the event call the Sub. You can then also call the sub with the other method you wanted.

 

[shg]

You don't explicitly call an event macro -- it's called by Excel in response to an event.

I don't know what book(?) you're referring to.

 

[mole999]

It'll be this book http://www.mrexcel.com/forum/mrexce...ual-basic-applications-macros-page-108-a.html but closer to http://www.mrexcel.com/store/index.php?l=product_detail&p=330