| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| declaring Excel constants | Excel Programming | |||
| Declaring Constants that can be used throughout the Workbook :) | Excel Programming | |||
| Declaring Objects | Excel Programming | |||
| Declaring array constants at module level | Excel Programming | |||
| declaring constants from the sheet? | Excel Programming | |||
Hybrid Mode
