View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default vba dim statement with equals


You can use a constant...
Const intValue As Integer = 5
However, you will then not be allowed to change it while code is running.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



wrote in message
Is there a way to combine a dim statement with setting the initial
value?
ex. dim intvalue=5 as integer