Does anyone know how to add a text box to an Excel Document?

I don't have a clue as to how to begin so if you could be descriptive,
that would be helpful.

I want someone to put in a value to the box, hit 'enter', and then have
the results of their value come up ...almost like a query...

Thanks


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Hi there,

Go to View-->Toolbars and select Control Box. The Control Box toolbar will
now be shown. Howver your mouse over each of the icons until you find the
textbox (it's a square icon with ab| in the picture).

You can then click and drag to create a textbox, but I'm not sure what you
mean by "hit enter" and then have the results of their value come up.
Perhaps you are looking for a lookup function whereby the user types in a
value and a corresponding value appears, eg enter in employee ID and the
corresponding employee name appears?

Cheers,
katherine

"cubd8" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Does anyone know how to add a text box to an Excel Document?
>
> I don't have a clue as to how to begin so if you could be descriptive,
> that would be helpful.
>
> I want someone to put in a value to the box, hit 'enter', and then have
> the results of their value come up ...almost like a query...
>
> Thanks
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>