Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving Text Boxes
I received the following suggestion to move text boxes
Sub moveit() With Workbooks("Book1.xls").Worksheets("Sheet1") .TextBox1.Top=Sheet1.Range("B2").Top .TextBox1.Left=Sheet1.Range("B2").Left End With End Sub I get a message straight away highlighting the first line (..With Workbooks etc) saying reference is out of range. Any suggestions? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving Text Boxes
Do you have a workbook named "Book1.xls" (not named Book1 - a default
workbook does not have an extension). And that workbook has a worksheet with a tab name of "Sheet1" Not having one of those is usually the cause of this message. Regards, Tom Ogilvy "phil perry" wrote in message ... I received the following suggestion to move text boxes Sub moveit() With Workbooks("Book1.xls").Worksheets("Sheet1") .TextBox1.Top=Sheet1.Range("B2").Top .TextBox1.Left=Sheet1.Range("B2").Left End With End Sub I get a message straight away highlighting the first line (..With Workbooks etc) saying reference is out of range. Any suggestions? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form Text Boxes - Copy format of text boxes | Excel Discussion (Misc queries) | |||
Print = moving check boxes | Excel Discussion (Misc queries) | |||
Moving Check Boxes | Excel Discussion (Misc queries) | |||
Moving. Want to number boxes and inventory contents of boxes | Charts and Charting in Excel | |||
Form Text Boxes moving | Excel Worksheet Functions |