Microsoft Press Step-by-Step is excellent if you are new to VBA
On Sep 16, 2:23 am, SilvergunSuperman <[EMAIL PROTECTED]> wrote:
> Would anyone be able to recommend a good book to purchase wrt to
> Macros and VBA?
>
> Thanks in advance!! : )
--~--~-~--~~~---~--~~
Use this, but change from currency format.
'
' Main Function *
'
Function SpellNumber(ByVal MyNumber)
Dim shillings, Cents, Temp
Dim DecimalPlace, Count
ReDim Place(9) As String
Place(2) = " Thousand
Hi,
If you provide us a copy of your current macro cade, we can give you ideas on
how to modify it to do what you want.
Regards - Dave.
> Date: Mon, 15 Sep 2008 18:17:10 -0700> Subject: $$Excel-Macros$$ Copy Paste
> Macro - Excel 2003> From: [EMAIL PROTECTED]> To:
> excel-macros@googlegroups.
Hi,
You could try a message box, in the appropriate place, which says something
like:
"Press OK when data is loaded."
The macro always pauses when a message box is displayed, and resumes when OK is
pressed.
Regards - Dave.
> Date: Mon, 15 Sep 2008 06:55:17 -0700> Subject: $$Excel-Macros$$ Paus
I am working through Excel for Scientists and Engineers (Numerical
methods) by E. Joseph Billo. It has several sections on the basics of
VBA
On Sep 15, 9:23 pm, SilvergunSuperman <[EMAIL PROTECTED]> wrote:
> Would anyone be able to recommend a good book to purchase wrt to
> Macros and VBA?
>
> T
Hi All,
I would like to learn and start using macros as my daily life involves lot
of routine excel jobs. I would be grateful if any one shares how to start
using macros.
Should i start learn VBA? Should i manage with the help of books or is it
mandatory to attend some practical classes.
regds
J
