Special Characters

  • Thread starter Thread starter BillR
  • Start date Start date
B

BillR

I do any programming by recording macros and then trying to adapt them to fit
my situation. I frequently run into unexplored territory. I need to know
where to find how to use ampersands, periods, quotes, etc.
Any help would be greatly appreciated.
thanks.
 
I don't think there is a specific answer for this. Just trial and error,
school of hard knocks, lots and lots of practice, etc. You can read books,
and read through posts here. Read as many posts as you have time for. Try
to answer some questions too!! You may be surprised about how much you
learn!!!!
 
Hi Bill,

For ampersand look up "operator summary" in Microsoft Visual Basic Help (use
ALT + F11 and select help ) and look under "concatenation operators".
Basically it is a way of adding strings i.e. "A" & "B" gives "AB"

Periods are used to create compound VBA commands e.g.
Range("A1").Select
will select cell A1 by using the range property in conjunction with the
select method joined by a period

Double quotes are used to surround strings. If you look at VBA help you will
see examples of its use. This is from the Select Method help:
Worksheets("Sheet1").Activate
where Sheet1 is being activated by code.

There are some great websites out there and I've learnt by borrowing code
from them and adapting it and trying to figure out how it works.
Unfortunately there is a lot to learn, but I guess thats why VBA is so
versatile.

HTH
 
Back
Top