Running vb6 in xl2000.

I can't assign a textbox to a textbox object. Why not?

Assume that TextBox1 and CommandButton1 are defined on some form, or
worksheet, then this works:

Dim cb As CommandButton
Set cb = CommandButton1

But this fails with a type mismatch:

Dim tb As TextBox
Set tb = TextBox1

I seems that TextBox1 does not refer to the TextBox as a whole, but to the
text that it contains, i.e. TextBox1.Text.

try (untested)
Set tb=Me.controls("Textbox1")

Bob Umlas
Excel MVP

"colin.." wrote in message
...
Running vb6 in xl2000.

I can't assign a textbox to a textbox object. Why not?

Assume that TextBox1 and CommandButton1 are defined on some form, or
worksheet, then this works:

Dim cb As CommandButton
Set cb = CommandButton1

But this fails with a type mismatch:

Dim tb As TextBox
Set tb = TextBox1

I seems that TextBox1 does not refer to the TextBox as a whole, but to the
text that it contains, i.e. TextBox1.Text.

Bob,
This still gives a type mismatch.
colin..


"Bob Umlas" wrote:

try (untested)
Set tb=Me.controls("Textbox1")

Bob Umlas
Excel MVP

"colin.." wrote in message
...
Running vb6 in xl2000.

I can't assign a textbox to a textbox object. Why not?

Assume that TextBox1 and CommandButton1 are defined on some form, or
worksheet, then this works:

Dim cb As CommandButton
Set cb = CommandButton1

But this fails with a type mismatch:

Dim tb As TextBox
Set tb = TextBox1

I seems that TextBox1 does not refer to the TextBox as a whole, but to the
text that it contains, i.e. TextBox1.Text.

There's a textbox in the Drawing toolbar, too.

You'll want to be specific about which type you want to use:

Dim tb As msforms.TextBox

there's only one commandbutton, but this wouldn't hurt:
dim cb as msforms.commandbutton

And might remind you why you did things that way.

colin.. wrote:

Running vb6 in xl2000.

I can't assign a textbox to a textbox object. Why not?

Assume that TextBox1 and CommandButton1 are defined on some form, or
worksheet, then this works:

Dim cb As CommandButton
Set cb = CommandButton1

But this fails with a type mismatch:

Dim tb As TextBox
Set tb = TextBox1

I seems that TextBox1 does not refer to the TextBox as a whole, but to the
text that it contains, i.e. TextBox1.Text.

--

Dave Peterson

Dave,
Many thanks -- that's solved it.
colin..

"Dave Peterson" wrote:

There's a textbox in the Drawing toolbar, too.

You'll want to be specific about which type you want to use:

Dim tb As msforms.TextBox

there's only one commandbutton, but this wouldn't hurt:
dim cb as msforms.commandbutton

And might remind you why you did things that way.

colin.. wrote:

Running vb6 in xl2000.

I can't assign a textbox to a textbox object. Why not?

Assume that TextBox1 and CommandButton1 are defined on some form, or
worksheet, then this works:

Dim cb As CommandButton
Set cb = CommandButton1

But this fails with a type mismatch:

Dim tb As TextBox
Set tb = TextBox1

I seems that TextBox1 does not refer to the TextBox as a whole, but to the
text that it contains, i.e. TextBox1.Text.

--

Dave Peterson