Register
Log In
Unanswered
Home
February 11, 2015
Offline
Hello
I'm wondering if there is a book or website that will list the available codes that one can use when writing a macro. i'm just learning so I'm not sure what is out there. For example, when writing formulas you go hit the "FX" button and it will bring up all available functions to use. Is this available in the macro developer tab?
Also, is there a macro that can be written to only look at certain tabs(worksheets) in a workbook? For example I may have 20 different tabs(worksheets) inside of my workbook, but I need my macro to look at only the 4 of these?
thanks so much
Amy
October 5, 2010
Offline
Hi Amy,
VBA is a programming language so you really would need to learn the language in order to use it. It's not a case of listing 'codes'.
Have a look at this VBA Starter course to give you an introduction to it.
You can also look though Miscrosoft's MSDN site:
With regards to 'looking' at certain tabs (worksheets), if you can describe exactly what it is you want to do, we can probably come up with a solution. What are you trying to do on each sheet?
Regards
Phil
Most Users Ever Online: 57
Currently Online: clark shao
9 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Sethu nath
Jose Alvarado
James Villapudua
Sheri O'Connor
Noreen Anagnos
Connie DeMercurio
Shanna Steinberg
Holly Seamons
Mark Cooper
David Matanana
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
