| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba dim statement with equals
Is there a way to combine a dim statement with setting the initial
value? ex. dim intvalue=5 as integer |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba dim statement with equals
I could be wrong, and it'd be interesting if someone were to tell me
different, but I'm 85 percent sure you can't do that. Constants are declared with an initial value, but that's because they're constants. " wrote: Is there a way to combine a dim statement with setting the initial value? ex. dim intvalue=5 as integer |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If a cell equals _, at the next row that equals _, return value fr | Excel Worksheet Functions | |||
| If cell is left blank, or equals zero, then cell equals a different cell | Excel Discussion (Misc queries) | |||
| if a:a (range) equals january and c:c equals gas then add g:g ($) | Excel Worksheet Functions | |||
| If statement where the logical test is a range that equals a word | Excel Worksheet Functions | |||
| custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) | |||
Linear Mode
