Form control not working

[Duane]

Hi,

The Text Box (aka Edit box) on the Froms toolbar is not
working in my Excel 2k. It worked yesterday, but today it
is not. My worksheet was open when a Copy bat program ran,
but that doesn't seem like it should make a difference.

I have "reset" the toolbar, but that did nothing.

Any suggestions?

Thanks

 

[Duane]

Solution-
I made the Control Toobar visible, and was able to use the
control from there. Why the Forms toolbox won't work is
beyone me. Microsoft may have a clever reason for
disabling functionality in one location while retaining
fuctionality in another, but I don't see why!

Duane

 

[Tom Ogilvy]

To the best of my knowledge, the EditBox was not designed to be used on a
worksheet - only on dialog sheets. There is a textbox on the Drawing
toolbar that works pretty much like the forms controls - it is a member of
the Textboxes collection and is designed to be used on the worksheet.

Regards,
Tom Ogilvy