Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, I'm using Worksheet_SelectionChange event in my workbook. On the very
begining of procedure I have some values initialized that I want to be constants like this: Dim x, y As String x = "C1" y = "H3" ... I guess it's bad solution to have them initialized in the event procedure because this way they get initialized every time event occurs. Where can I put them to be initialized once and visible for Worksheet_SelectionChange and other subs? Shall I also set them at nothing and where when exiting workbook? Thanx alekmil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Constants in Excel | Excel Discussion (Misc queries) | |||
Range Name Constants | Excel Discussion (Misc queries) | |||
Constants In Formulae | Excel Discussion (Misc queries) | |||
Flagging constants | Excel Worksheet Functions | |||
constants | Excel Discussion (Misc queries) |