Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
text box reference
Hello,
Instead of referencing my form text box to a cell on the active sheet(see code below which works): Private Sub UserForm_Activate() TextBox1.Text = ActiveSheet.Range("ag11").Value End Sub I am trying to reference it to a text box on the sheet. However, the following code does not work: Private Sub UserForm_Activate() TextBox1.Text = ActiveSheet.Shapes("Text Box 62").Text End Sub It gives me a run time error 438 (object does not support thisproperty or method). Any idea. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Reference | Excel Discussion (Misc queries) | |||
Cell reference within text? | Excel Discussion (Misc queries) | |||
How do I put text and a cell reference in a text box? | Excel Discussion (Misc queries) | |||
Reference date as text | Excel Worksheet Functions | |||
How can I reference data or text within a text box to a cell in Ex | Excel Discussion (Misc queries) |