Mary,

If you're using Excel 2007, click on the Developer tab, and then, in the
Active X controls part of the buttons ribbon click on "Design Mode". It's
the second button from the left in that section. Then when you're done,
click on the Design mode button again, to turn off design mode. I've
noticed, however, that if you click once on the text box with the right-click
button suppressed, it will often go into design mode (even when not in Design
Mode). Maybe this is why the text box in Excel 207 is so unstable. When I
tested a form I designe din Excel 2007, a lot of my test group could not writ
ein the active X text box, even though it functioned for me perfectly. They
were all also using Excel 2007. Another thing to keep in mind when opting to
use the Active X text box control in Excel 2007 is that it doesn't translate
functionally into Excel 2003. The drop-downs do. What I ended up doing is
eliminating all of the Active X text boxes and using a blank cell instead. I
then used dynamic linking to get the data from the blank cell to where I
wanted to populate it into a hidden row for transport into a master workbook.

I hope this is helpful.

Karen

"Mary Thomas" wrote:

Hi there!
I've inserted several ActiveX Control text boxes into an excel form. A
couple of them are too small and I need to make them bigger but I can't grab
anything to drag them.
Help!?
Not an expert so please keep it somewhat simple.
Thanks,
Mary
--
MT