![]() |
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.) |
All times are GMT +1. The time now is 08:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com