Be simple.
You might be well aware of command buttons, drop downs, Text box,
check box etc.....
Well these are called CONTROLS or OBJECTS.
Either You are a programmer or not you might be well aware of these
controls,
You interact with these controls using keyboard or mouse or other
input divices.
Example with mouse You can click, double click, right click, drag &
drop objects etc.
As well with keyboard you press the keys on the keyboard, known as
typing, means you press the keys.
These are nothing but called EVENTS (click, double click, right click,
keypress).
You expect something by CLICKING on a COMMAND BUTTON.
These expectations means, what should happen when an event is written
an EVENT-PROCEDURE
Simple Example.
You have a FORM.
It Contains a Command Button.
You want to display a message "Command Button was clicked" when the
command button is clicked.
So You write the code in the event procedure
Sub CommandButton_Press
Msgbox "Command Button was clicked"
End Sub
Let us see the BIG PICTURE.
Revisit CONTROLS/OBJECTS: command buttons, drop downs, Text box, check
box are simple controls.
Worksheet, Workbook are composite objects, which are made with other
objects ie, rows, columns, cells etc.
Workbook contains worksheets (collection of worksheet).
Worksheet contains rows, columns, cells etc.
Just like a Human body contains different organs (objects) like heart,
brain, stomack etc each will have its own functions (event procedure).
and each orgon inturn is made up of different types of cells (basic
controls).
This is called OBJECT ORIENTED PROGRAMMING or EVENT DRIVEN
PROGRAMMING.
Regards,
Kishan Reddy, K
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
