Change events in MS Excel

Asked By 7060 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 10 points N/A #81134

Change events in MS Excel

qa-featured

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.

Login/Register to Answer

Related Questions