visual basic in excel dictionary/glossary of command terms

  • Thread starter Thread starter bill
  • Start date Start date
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 :-\
 
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.
 
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
 
Back
Top