Declaring Constants: objects

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dim cht as Object Constant Declaration 4
Object Module Constants Scope 1
Finding last constant in range 1
Sum If - Using the value of a parameter or constant in a formula tochange a condition 1
Declare a Public Array 5
Declaring a constant to the Workbook Name? 3
Set Global Variable Inside Object Module 3
declaring constants from the sheet? 4

Back
Top