|
PureBytes Links
Trading Reference Links
|
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META content='"MSHTML 4.72.3110.7"' name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#000000 size=2>LP, have sent a message each day. Something
wrong with your ISP (@home.com) ?</FONT></DIV>
<DIV><FONT color=#000000 size=2></FONT> </DIV>
<DIV><FONT color=#000000 size=2>Marianne</FONT></DIV></BODY></HTML>
</x-html>From ???@??? Wed Aug 11 09:13:50 1999
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
by purebytes.com (8.8.7/8.8.7) with ESMTP id JAA24282
for <neal@xxxxxxxxxxxxx>; Wed, 11 Aug 1999 09:12:41 -0700
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id XAA02345
for metastock-outgoing; Wed, 11 Aug 1999 23:47:29 -0600
X-Authentication-Warning: listserv.equis.com: majordom set sender to owner-metastock@xxxxxxxxxxxxx using -f
Received: from freeze.metastock.com (freeze.metastock.com [204.246.137.5])
by listserv.equis.com (8.8.7/8.8.7) with ESMTP id XAA02342
for <metastock@xxxxxxxxxxxxxxxxxx>; Wed, 11 Aug 1999 23:47:26 -0600
Received: from hme0.mailrouter02.sprint.ca (hme0.mailrouter02.sprint.ca [207.107.250.60])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id JAA23318
for <metastock@xxxxxxxxxxxxx>; Wed, 11 Aug 1999 09:36:35 -0600 (MDT)
Received: from walter (spc-isp-ott-uas-19-25.sprint.ca [209.103.36.176])
by hme0.mailrouter02.sprint.ca (8.8.8/8.8.8) with SMTP id LAA29373
for <metastock@xxxxxxxxxxxxx>; Wed, 11 Aug 1999 11:23:21 -0400 (EDT)
Message-ID: <000b01bee40e$2720f920$b02467d1@xxxxxx>
From: "Walter Lake" <wlake@xxxxxxxxx>
To: "Metastock bulletin board" <metastock@xxxxxxxxxxxxx>
Subject: VBA code
Date: Wed, 11 Aug 1999 11:28:23 -0400
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
For those experiencing difficulty moving into VBA programming, the following
has helped me.
Open a blank workbook --> reduce to half screen. Open the Visual Basic
Editor (Alt+F11) --> reduce to half screen so that both are open side by
side.
Activate the open work book --> start the macro recorder.
In the open VBE activate the module where the macro is recording.
Enter data, formulas, drawings, etc. into the workbook and watch the code
being written in the VBE window.
As you probably know, the macro recorder writes inefficient (i.e., excess)
code, this can be corrected as you learn to program in VBA. You will at
least see all of the objects, methods and procedures for the keyboard and
mouse actions that you take.
Just "fooling around" in the workbook and watching the code being written
sure removed a lot of "fear and anxiety" in me. It's a lot easier that it
looks to the non-programmer.
There is no "time limit" on the macro recorder so you can experiment at will
without fear out "running over" or " running out" of time. Take your time
and enjoy your "in-house programmer".
Best regards
Walter
|