Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Special character in code

0 views
Skip to first unread message

gargoyle60

unread,
Dec 9, 2009, 11:52:09 AM12/9/09
to
I've seen some VBA code that uses the # character after a function
name.

I know about the $ character, but what is the # character for/what
does it do?

Thanks

Banana

unread,
Dec 9, 2009, 12:06:29 PM12/9/09
to gargoyle60

Like $ character, it seems that # is used as a type declaration, but
returning a Double instead of String for $ and Variant for none.

So this is equivalent:

Public Function Testit() As Double
Public Function Testit#()


Sounds like you're looking at real old-school VBA code... Type
declaration character is nowadays deprecated and not recommended.

gargoyle60

unread,
Dec 9, 2009, 2:12:26 PM12/9/09
to

Thanks for that info.

I have some code originally obtained from
http://groups.google.co.uk/group/microsoft.public.vb.general.discussion/browse_thread/thread/494c8aa24a624350/cfe86aa06c8c47eb%23cfe86aa06c8c47eb

0 new messages