FiveTech Software tech support forums

by **bterce@matrixcomputer.com** » Mon Apr 23, 2007 6:27 pm

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

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

http://fox.wikis.com/wc.dll?Wiki~ExcelConstants~VFP

EMG

by **bterce@matrixcomputer.com** » Mon Apr 23, 2007 9:54 pm

Enrico, thanks a lot for your help.

Bert

by **Gale FORd** » Mon Apr 23, 2007 10:21 pm

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.

by **bterce@matrixcomputer.com** » Tue Apr 24, 2007 5:01 pm

Thanks GALE

Bert

by **sysctrl2** » Tue Apr 24, 2007 6:57 pm

Hi,

an example of the use of these constants?

thank you,

FiveTech Software tech support forums

CONSTANTS used in Excel

CONSTANTS used in Excel

Re: CONSTANTS used in Excel

Who is online