What is the #define equivalent?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sing - 25 Sep 2007 16:29 GMT

Dear Excel Gurus,

In C, one can make convenient definitions like;
#define ABC 242
#define NAME "James Smith"

In Excel VBA, is there an equivalent for #define?

Thanks.

Reply to this Message

Bob Phillips - 25 Sep 2007 16:33 GMT

Const

say

Const ABC as long = 242

Const NAME as string = "James Smith"

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Dear Excel Gurus,
>
[quoted text clipped - 5 lines]
>
> Thanks.

Reply to this Message

Jim Thomlinson - 25 Sep 2007 17:16 GMT

VBA does not have a preporcessor the same as C does. What you have posted are
just constants which are handled, but if you wanted to get into defining
formulas and such then you are out of luck.

Signature

HTH...

Jim Thomlinson

> Dear Excel Gurus,
>
[quoted text clipped - 5 lines]
>
> Thanks.

Reply to this Message