Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 VBA and Text Boxes
I am a new to Excel 2007. I have been using Excel and VBA for 10+ years.
My problem is I cannot get VBA in Excel 2007 to recognize Text boxes I have on a worksheet. I have a number of legacy (2003) workbooks that contain text boxes that are modified by VBA code. When I try to run the 2003 code in a 2007 workbook I get an error.....€¯Item with the specified name wasnt found€¯ When I use the macro record in 2007 to record actions on shapes they record nothing. e.g. Create a text box and add text and color the box. My result ... Sub Macro1() ' ' Macro1 Macro ' ' End Sub .......absolutely nothing....I wonder if anyone could help. What am I doing wrong? Thanks Gary |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default font for pasted text in text boxes - Excel 2007 | Excel Discussion (Misc queries) | |||
Tabbing between text boxes in Excel 2007 | Excel Discussion (Misc queries) | |||
Spelling and text boxes in Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 Text Boxes | Excel Discussion (Misc queries) | |||
Superscrpts in Excel 2007 Text boxes | Excel Programming |