variable declaration

S

seeker

I have this public declaration in a module

Public intcount as integer = 10

It gives me a expected end of statement error. Need wisdom.
 
J

Jeff Boyce

A bit tough to diagnose without a bit more context...

More info, please.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

Jeff Boyce

By the way, I don't believe you can set the value at the same time you 'dim'
the variable...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
B

Bob Barrows

seeker said:
I have this public declaration in a module

Public intcount as integer = 10

It gives me a expected end of statement error. Need wisdom.
Click to expand...

VBA != VB.Net

Try
Public intcount as integer: intcount = 10
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

converting VBA password-masking code to 64-bit 0
Making a macro only work on certain files 2
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
VBA word change keys 0
Declaring Variables 3
Variables in select statement 1
How/where to declare variables shared by objects of a class? 3
#Error in Results 5

Top