<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
To be truthful Teresa I think the best way is simply to use the macro
recorder to do some simple operations in a spreadsheet and then
deconstruct the coding of the macros (alt F11) you have recorded by
changing some of the parameters (cell range, cell colour.
operator...whatever).<br>
<br>
It's probably a heretical way to teach it but I don't think it's worth
going through VBA from first principals with Apps students, it's just
not the focus of the course it seems to me.<br>
<br>
regards,<br>
<br>
Brett Groves<br>
ICT Manager<br>
Croydon Secondary College<br>
<br>
On 16/07/10 09:06, Peluso, Teresa T wrote:
<blockquote
cite="mid:8F170F73C853BB4AA795891C05BC4755020B006E@edusm04.education.vic.gov.au"
type="cite">
<meta http-equiv="Content-Type"
content="text/html; charset=ISO-8859-1">
<title>itapps Digest, Vol 65, Issue 10</title>
<meta content="MSHTML 6.00.6002.18226" name="GENERATOR">
<div id="idOWAReplyText21091" dir="ltr">
<div dir="ltr"><font size="2" color="#000000" face="Arial">Hi </font></div>
</div>
<div dir="ltr"> </div>
<div dir="ltr">I am looking for tutorials or activities using macros
in excel.</div>
<div dir="ltr"> </div>
<div dir="ltr">Regards, </div>
<div dir="ltr">Teresa</div>
<div dir="ltr"> </div>
</blockquote>
<p></p><p><b>Important - </b>This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.</p>
</body>
</html>