Thread: Edit Boxes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Earl Kiosterud Earl Kiosterud is offline
external usenet poster
 
Posts: 611
Default Edit Boxes

Matthew,

The Edit Box (Forms Toolbar on a worksheet form) isn't available on a
worksheet. You could use a text box from the Controls Toolbox instead. It
can be linked to a cell. Use the Linked Cell property:
Turn on Design Mode (button on Controls Toolbox)
Right click your text box - Properties
Type the cell address into the Linked Cell property. Press Enter
Turn off Design Mode to use your text box.
--
Earl Kiosterud
www.smokeylake.com

"Pflugs" wrote in message
...
Hello,

Does anyone know why I cannot enter an edit box into my Excel Form? All
the
other buttons work, and I could just link a cell, but how do I use edit
boxes?

Thanks,

Matthew