Hugh,
Many thanks for the useful info. I believe that you have solved my problem and the key is "SET". To apply it to what I need to do I need to do it without the arrays:
Dim nonArray As Variant
Set nonArray = Chalkboard.l1
MsgBox (nonArray.Value)
I think this is going to work as I...
Hi,
This is simplified version of what I am trying to do.
I have an Excel form called aForm with three textboxes:
textBox1
textBox2
textBox3
What I would like to do is check the contents of each from one function by making the textbox names variables, but I am stuck with code like this:
01...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.