Change events in MS Excel

Asked By anonymous 7060 points N/A Posted on - 10/19/2011

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?

• Status: Open
• Question Views: 972
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By lee hung 75 points N/A #81134

Change events in MS Excel

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.

About lee hung

Questions
3

Answers
1451

Best Answers
463

• Vote Up 0 Vote Down

• Posted on - 10/23/2011
• Question Category: MS Excel