visual basic in excel dictionary/glossary of command terms

B

bill

when using VB, it would be helpful to have a concise dictionary of terms to
describe their meaning, interpretation and use. For example when I type:

Dim something As String

What does 'Dim' mean and do?

etc. etc. etc. for all terms that Visual Basic in Excel recognises and
understands.

Is there such a thing?

I have 'VB for Dummies' in pdf, but it does not contain this information
accessibly and the 'glossary of terms' in help doesn't seem to cover this
either :-\
 
R

Rick Rothstein

You could trying clicking in or immediately next to the keyword you want to
know about (this puts the text cursor at the clicked location) and then
pressing F1 to bring up the help files for that keyword.
 
M

Matthew Herbert

Bill,

I know the following statement is a generalization, but I find too often
that it's true: People don't use Help. The Help documentation is rather
good and too often under utilized. Yeah, the search engine behind it might
not be a Bing or Google, but the information is there.

When you are in VBE, simple put the cursor somewhere in the word (i.e.
native VBA words) and hit the F1 key. So, if my cursor is between "D" and
"i" in the word "Dim", the help opens to the following document: "Dim
Statement". Go ahead and read the help file for "Dim Statement".

Another spot to check out is the Object Browser (F2 within VBE). You can
look up objects, properties, methods, etc. within the Object Browser. If you
highlight a word within the Object Browser, simply hit F1 to get the help
documentation.

Best,

Matthew Herbert
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top