Thread: Use of Variable
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default Use of Variable

Use:
Public vcol1 as Integer
"Jim May" wrote in message
...
If in a standard module I have an interger variable and I wish to be able
to
use this variable later in a sheet_change event, what exactly would I do?
Above the Standard module I put:

Global vcol1 as Interger

But I'm not sure what else I am to do in order to have it later to use in
my
Sheet_Change event code.