Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > VBA / Office Integration > Excel > VBA Commands Listing


Reply
 
Thread Tools Display Modes
  #1  
Old 03-23-2003, 08:03 PM
KCalvert KCalvert is offline
Newcomer
 
Join Date: Mar 2003
Location: Pittsburgh, PA
Posts: 7
Default VBA Commands Listing


I am an extreme newbie when it comes to VBA in Excel. Which is why I am here trying to learn. I've already found quite a few things on here helpful and am beginning to learn a few things here and there. But what I want to know is if there is a listing somewhere to lists all of these Excel VBA commands (I'm only interrested in using Excel commands as of now). I don't know if "commands" is the right word here but what I mean is things like Range("A1") and Range.Select.Copy (I know those aren't right ).

Any help would be appreciated and I'm sure you'll hear a lot more from me in the future.

Thanks
Reply With Quote
  #2  
Old 03-23-2003, 08:17 PM
starbitz's Avatar
starbitz starbitz is offline
Junior Contributor
 
Join Date: Feb 2003
Location: Philippines
Posts: 336
Default

Quote:
Originally Posted by KCalvert
I am an extreme newbie when it comes to VBA in Excel. Which is why I am here trying to learn. I've already found quite a few things on here helpful and am beginning to learn a few things here and there. But what I want to know is if there is a listing somewhere to lists all of these Excel VBA commands (I'm only interrested in using Excel commands as of now). I don't know if "commands" is the right word here but what I mean is things like Range("A1") and Range.Select.Copy (I know those aren't right ).

Any help would be appreciated and I'm sure you'll hear a lot more from me in the future.

Thanks



you can try recording a macro on excel. it will generate the corresponding codes you do to excel. and you can copy it to yuor vb codes
Reply With Quote
  #3  
Old 03-23-2003, 08:23 PM
KCalvert KCalvert is offline
Newcomer
 
Join Date: Mar 2003
Location: Pittsburgh, PA
Posts: 7
Default

Quote:
Originally Posted by starbitz
Quote:
Originally Posted by KCalvert
I am an extreme newbie when it comes to VBA in Excel. Which is why I am here trying to learn. I've already found quite a few things on here helpful and am beginning to learn a few things here and there. But what I want to know is if there is a listing somewhere to lists all of these Excel VBA commands (I'm only interrested in using Excel commands as of now). I don't know if "commands" is the right word here but what I mean is things like Range("A1") and Range.Select.Copy (I know those aren't right ).

Any help would be appreciated and I'm sure you'll hear a lot more from me in the future.

Thanks



you can try recording a macro on excel. it will generate the corresponding codes you do to excel. and you can copy it to yuor vb codes



Surprisingly, I have figured that out.

I'm just looking for a <i>full</i> listing of all the available commands and options and such.
Reply With Quote
  #4  
Old 03-24-2003, 06:25 AM
Mill Mill is offline
Just another Excel nerd

Retired Moderator
* Guru *
 
Join Date: Feb 2000
Location: Michigan, USA
Posts: 2,631
Default

While in VBA, hit your <F2> key to view the Object Browser. That should list all of the available objects, classes, and commands available to you, but it may take you a bit of time to understand the format of it.
__________________
"The face of a child can say it all, especially the mouth part of the face." - Jack Handey
Reply With Quote
  #5  
Old 03-24-2003, 06:26 AM
JordanChris JordanChris is offline
Senior Contributor

* Expert *
 
Join Date: Jan 2003
Location: Newbury, UK
Posts: 1,092
Default

Use the help system.
Excel, Macro, VB Editor, F1.
You can get a list of all objects, methods, properties and Events.

Alternatively, there might be something on www.MrExcel.com
Reply With Quote
  #6  
Old 03-24-2003, 09:02 AM
KCalvert KCalvert is offline
Newcomer
 
Join Date: Mar 2003
Location: Pittsburgh, PA
Posts: 7
Default

Thanks guys. Will do.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Commands and DB Providers PizzaYoda Database and Reporting 13 10-14-2002 12:43 PM
Commands to controlling keyboard's event(Pls See) Rei_Max General 2 10-07-2002 03:16 AM
vb commands for executing system commands needed shofstetter General 5 09-17-2002 09:17 PM
Processing commands rimby General 2 06-08-2002 09:17 AM
winsock chat commands phire Communications 7 03-27-2002 07:33 PM

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->