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 <(E-Mail Removed)>,
"Corey" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
news:jemcgimpsey-(E-Mail Removed)...
Compiles fine here. Did you paste it in (sometimes browsers use
non-breaking spaces to indent - deleting the whitespace removes the
error)?



In article <(E-Mail Removed)>,
"Corey" <(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 <(E-Mail Removed)>,
"Corey" <(E-Mail Removed)> wrote:

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