Page 1 of 1

CONSTANTS used in Excel

Posted: Mon Apr 23, 2007 6:27 pm
by bterce@matrixcomputer.com
Hi

How and where do you find the value of CONTANTS used in Excel, ex: xlCenter, xlRight,xlAutomatic, etc? I've search in the .CHM files but didn't find them? I'm recording a MACRO and trying to convert them into Fivewin codes. Please help.

Bert

Re: CONSTANTS used in Excel

Posted: Mon Apr 23, 2007 8:34 pm
by Enrico Maria Giordano

Posted: Mon Apr 23, 2007 9:54 pm
by bterce@matrixcomputer.com
Enrico, thanks a lot for your help.

Bert

Posted: Mon Apr 23, 2007 10:21 pm
by Gale FORd
If you recorded the macro, then in the Visual Basic Editor you can just right click on the constant and select "Quick Info" and it will show you the value.

Posted: Tue Apr 24, 2007 5:01 pm
by bterce@matrixcomputer.com
Thanks GALE

Bert

Posted: Tue Apr 24, 2007 6:57 pm
by sysctrl2
Hi,

an example of the use of these constants?

thank you,