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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
text box reference
Private Sub UserForm_Activate()
TextBox1.Text = ActiveSheet.TextBoxes("Text Box 62").Text End Sub Text Box 62 would be consistent with a Textbox from the Drawing toolbar demo the objects from the immediate window: ? activeSheet.Textboxes("Text Box 62").Text This is my text -- Regards, Tom Ogilvy "Caroline vincent" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
text box reference
try this:
ActiveSheet.Shapes("Text Box 62").Select TextBox1.Text = Selection.Text -----Original Message----- 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
text box reference
Thanks it works
-----Original Message----- 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 . |
Reply |
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) |