Compile error when using Res=Inputbox

[Corey]

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


Corey....

 

[JE McGimpsey]

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

 

[Corey]

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

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

 

[NickHK]

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]

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

Thanks

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

 

[JE McGimpsey]

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...