CONSTANTS used in Excel

Post Reply
bterce@matrixcomputer.com
Posts: 10
Joined: Mon Mar 05, 2007 11:18 pm
Location: Southern California

CONSTANTS used in Excel

Post 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
bterce@matrixcomputer.com
Posts: 10
Joined: Mon Mar 05, 2007 11:18 pm
Location: Southern California

Post by bterce@matrixcomputer.com »

Enrico, thanks a lot for your help.

Bert
Gale FORd
Posts: 663
Joined: Mon Dec 05, 2005 11:22 pm
Location: Houston
Contact:

Post 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.
bterce@matrixcomputer.com
Posts: 10
Joined: Mon Mar 05, 2007 11:18 pm
Location: Southern California

Post by bterce@matrixcomputer.com »

Thanks GALE

Bert
User avatar
sysctrl2
Posts: 833
Joined: Mon Feb 05, 2007 7:15 pm
Contact:

Post by sysctrl2 »

Hi,

an example of the use of these constants?

thank you,
Cesar Cortes Cruz
SysCtrl Software
Mexico

' Sin +- FWH es mejor "
Post Reply