Yes you can, so it looks like the initialising code is failing.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jim May" wrote in message
...
vcol1 is created and assigned the integer 9 in my standard module -- I
place
in the declaration section of the same standard module Public vcol1 as
Integer

Surely I can use this in a sheet_change event 5 seconds later...

"Chip Pearson" wrote:

You can't create a purely Public variant in an object module, such as
ThisWorkbook, a Class, a Sheet, or a UserForm code module. Truly Public
variables must reside in a standard module.

Public XYZ As Long

If you declared it in an object module, you'd have to reference it using
the
module or instance name. E.g., in a UserForm,

Public ABC As Long

Now in a standard code module:

ABC = 1234 ' doesn't work
Userform1.ABC = 1234 ' works fine


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)




"Jim May" wrote in message
...
I replaced Global vcol1 as Integer
with
Public vcol1 as Integer

but as soon as I run my macro in my Standard Module and I go to the
immediate
Window and enter ? vcol1 and <return
I get 0, versus say 9



"Otto Moehrbach" wrote:

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.