ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA - xl Prefix (https://www.excelbanter.com/excel-programming/346674-vba-xl-prefix.html)

ajocius[_43_]

VBA - xl Prefix
 

Group,
xlToLeft, xlBottom, xlSolid, xlAutomatic, and
xlPasteValuesAndNumberFormats to name a few. What are these called and
where can I get a list of them. I see them everywhere.

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=488396


Gord Dibben

VBA - xl Prefix
 
ALT + F11 to open VB Editor.

ViewObject Browser

In this window select "All Libraries" from the drop down at top left.

Scroll down in the Classes <globals list and you will find the xlyyyyy
properties list.

Click on one of these and you will get a list of the methods for each.


Gord Dibben Excel MVP

On Sat, 26 Nov 2005 13:43:27 -0600, ajocius
wrote:


Group,
xlToLeft, xlBottom, xlSolid, xlAutomatic, and
xlPasteValuesAndNumberFormats to name a few. What are these called and
where can I get a list of them. I see them everywhere.

Tony




All times are GMT +1. The time now is 08:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com