Adding a Text Box

[cubd8]

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

 

[Katherine Coombs]

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