explain VBA

Can someone explain VBA to me. I cant do a search on it. I think it deals with automaticly sending an e-mail when certain criterias are met. I am in need of this function but dont even know where to write a macro in let alone write one.
Example:
workbook has 31 sheets. when information is completed on a sheet, the data entry person will put an X in the completed box and save. That will automaticly send a range of cells from that sheet to 3 different e-mails.
where do I begin?

Simpson,

VBA is a programming language within Excel. There's a lot to learn, so someone can't simply teach you VBA. I've learned a little, mainly by hanging around in the Excel Programming section of this forum.

To send an email a good place to start is Ron Debruin's website:
http://www.rondebruin.nl/sendmail.htm

One way I find out how to do things in VBA is through Google, doing searches like "macro to copy range" or "copy cells with Excel VBA". Searching through the Tips section and programming section of this and other forums will also teach you lot. Use the search key to look up various problems and solutions.

I'm sure others will give you more advice. Good luck.

Jomili, you beat me,

Was going to refer the OP to

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

chemistB,

yes they will be sent using outlook, yes, same cells on every sheet every e-mail. A designated completion signature cell would be created on the sheet. When any value was added to that cell an e-mail would be generated.