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