Change events make things easier. Can anybody guide me that while using change events in MS Excel, how can I avoid not going to be drastically increasing the size of my workbook?
Hi Sarah,
To use change events in ms excel, you have to have an access to the Visual Basic Application (VBA) interface. You can access by simply pressing ALT+F11 key combination on your keyboard.
When the Visual Basic Editor opens click on the module named sheet which is the project explorer. You can add modules, delete modules and add other functionalities that will otherwise not be implementable in the general ms excel GUI.
I will refer you to the following link, for a detailed explanation on how to use change_event and manipulate ms excel macros, please just access the following site:
http://www.ozgrid.com/VBA/run-macros-change.htm
Hope this helps.
__
Regards,
Lee Hung.
