res = InputBox("Please enter a Customer Name here", "....")
I get an error with this NOW?
Why?
How to fix?


Corey....

Compiles fine here. Did you paste it in (sometimes browsers use
non-breaking spaces to indent - deleting the whitespace removes the
error)?



In article ,
"Corey" wrote:

res = InputBox("Please enter a Customer Name here", "....")
I get an error with this NOW?
Why?
How to fix?


Corey....

The Compile error says:
Variable Not Defined?
I removed the Spaces but they return and the same error occurs.

"JE McGimpsey" wrote in message
...
Compiles fine here. Did you paste it in (sometimes browsers use
non-breaking spaces to indent - deleting the whitespace removes the
error)?



In article ,
"Corey" wrote:

res = InputBox("Please enter a Customer Name here", "....")
I get an error with this NOW?
Why?
How to fix?


Corey....

Corey,
That one line of code, as written, compiles.
Of course, you should be using Option Explicit, and then you would need to
Dim res.
There must be something else you are not including.

NickHK

"Corey" wrote in message
...
res = InputBox("Please enter a Customer Name here", "....")
I get an error with this NOW?
Why?
How to fix?


Corey....

That was it Nick.
I changed my project to Option Explicit
Yet did not dim res as variant

Thanks

"NickHK" wrote in message ...
Corey,
That one line of code, as written, compiles.
Of course, you should be using Option Explicit, and then you would need to
Dim res.
There must be something else you are not including.

NickHK

"Corey" wrote in message
...
res = InputBox("Please enter a Customer Name here", "....")
I get an error with this NOW?
Why?
How to fix?


Corey....

Then you need to define the variable...


Dim res As String

or

Dim res As Variant

You usually get that error when you have "Option Explicit" at the top of
your module. It's a GOOD thing. Keeps you from tearing your hair out
over thing like:

Dim result As String

'lots of code here

res = Inputbox("...")

'lots more code

If result = "foo" Then
'...

where result never gets assigned...

In article ,
"Corey" wrote:

The Compile error says:
Variable Not Defined?
I removed the Spaces but they return and the same error occurs.