View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
colin.. colin.. is offline
external usenet poster
 
Posts: 4
Default Can't assign a textbox to object

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.