VBA Codes

[Lee Kiwiflame]

Does anybody know where I can find a list or internet place where I can find
VBA general codes, e.g. vbCr, vbCancel etc (all vb codes), and what they are
used for.
I know the object browser has these within it but it doesn't give you an
explanation of how they could be used or what they are used for.

 

[Lee Kiwiflame]

Sorry - I think I am also after a list of all Chr() codes as well. I know a
soft return (Shift + Enter) is Chr(11) but I need a list of all the others.
Chr(11) comes up as a square box in the list on the VBA help menu.

 

[old man]

Hi,

Chr codes are ascii characters. Look up for an Ascii table in any search
engine and you will get a list of characters that correspond to the chr(xx)
values.

To see a list of constants try these two links:
http://msdn2.microsoft.com/en-us/library/d1wf56tt.aspx
http://msdn2.microsoft.com/en-us/library/z9yesb15.aspx

I am sure several of these won't work but the majority will.

old man

 

[old man]

Wikipedia has a really good list of Ascii codes and what they do:
http://en.wikipedia.org/wiki/ASCII.

To understand what chr(13) does look at the first table in URL above.

old man