Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. (Apologies if this is a duplicate message €“ getting random error messages from MS discussion group website.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to assign value to a textbox. | Excel Worksheet Functions | |||
assign keystroke to object or button | Excel Worksheet Functions | |||
Can't assign a textbox to object | Excel Programming | |||
assign the sub to the object event | Excel Programming | |||
Assign a variables value to a TextBox | Excel Programming |