Need VBA help with "Compile error: Variable not defined"

[Mark Carlson]

This is my first post. Greetings from Athens, TX!

I've used Excel for many years, but finally am learning VBA, using Excel Progamming for Dummies by John Walkenbach. Excel is version 2000.

I've searched extensively on Google and on the MrExcel site for the solution to my problem, but still haven't found it . Any direction would be most appreciated.

I'm trying to execute the examples in the book, and have gotten the error message "Compile error: Variable not defined" with "MyString =" highlighted with several of the examples. Could someone please tell me where I'm going astray?

Following is the latest subroutine I typed into the module, from page 124:

Option Explicit

Sub GetLength()
MyString = "Hello World"
StringLength = Len(MyString)
MsgBox StringLength
End Sub

Thank you for your help!

Mark Carlson

 

[Mark Carlson]

Greg,

That worked fine! Thank you so much.

When you said, "The code tags are what I used above to make the code line stand out.", I don't see what you are referring to.

Thanks again, Mark

 

[RoryA]

I'm not Greg!
When posting code if you prefix it with a [ code ] tag (without the spaces) and terminate it with a [ / code ] tag (again without spaces), it gets proper formatting. For example, if you enter:
[ code ]here is some code[ / code ]
without the spaces in the tags, you get:

here is some code

Regards,
Rory

 

[Mark Carlson]

Thanks, Rory,

I didn't even notice that a new person was in the thread!


What do you mean by, "to make the code line stand out"?

Thanks again, Mark

 

[RoryA]

Without code tags, my post would have looked like this:

Dim MyString As String, StringLength as Long


as opposed to this:

Dim MyString As String, StringLength as Long