ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Declaring Constants: objects (https://www.excelbanter.com/excel-programming/367682-declaring-constants-objects.html)

comparini3000

Declaring Constants: objects
 
How/where do I declare constants (in general). If I'm declaring an object
constant, would I go about it differently than other constants (since object
variables require "set...")? Any help is deeply appreciated

Andre

Tom Ogilvy

Declaring Constants: objects
 
Not supported. From VBA help on Const:

Optional. Data type of the constant; may be Byte, Boolean, Integer, Long,
Currency, Single, Double, Decimal (not currently supported), Date, String, or
Variant. Use a separate As type clause for each constant being declared

--
Regards,
Tom Ogilvy


"comparini3000" wrote:

How/where do I declare constants (in general). If I'm declaring an object
constant, would I go about it differently than other constants (since object
variables require "set...")? Any help is deeply appreciated

Andre



All times are GMT +1. The time now is 10:35 AM.

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