| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear Text in Text Box control
I am using the following to clear the text in a text box:
Sheet2.Shapes("TB1").OLEFormat.Object.Text = "" I found this solution on a previous post in this newsgroup and unfortunately when I use it I get an error - Object doesn't support this property or method. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Clear Text in Text Box control
How about Sheets("Sheet2").TB1.Value = ""
Die_Another_Day Qaspec wrote: I am using the following to clear the text in a text box: Sheet2.Shapes("TB1").OLEFormat.Object.Text = "" I found this solution on a previous post in this newsgroup and unfortunately when I use it I get an error - Object doesn't support this property or method. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| clear text | Excel Discussion (Misc queries) | |||
| Bolding text in a control text box. | Excel Discussion (Misc queries) | |||
| Text Control - Wrap Text | Excel Discussion (Misc queries) | |||
| Limiting physical length of text in a text box control | Excel Discussion (Misc queries) | |||
| Tool Tip Text for Form control/ Active-X control | Excel Programming | |||
Linear Mode
