MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VBA Shortcuts for DIM

Posted by Ed J. on January 30, 2001 12:52 PM

I can't find online documentation of the shortcuts for typing a variable.

If the code reads:

DIM r%, x!

What have I got? I assume the "%" is for "as integer", but I can't come up with what the "!" would mean. Where can I find this info?

Posted by Dax on January 30, 2001 1:44 PM

I don't know if or where it is in the on-line help but these are the short cut ways of declaring variables:-
$ String
% Integer
& Long
! Single
# Double