Combobox w/ Predictive Text?

[samsilverman]

I'm using excel 2007.

I need to insert a text box on a worksheet that will allow me to type in comments for the client to read when we send out a report.

A simple text box I can do.

What I would like is to have a text box that "remembers" previous entries so I don't have to type out the whole comment. We could do this with Access. I think it was a combobox. Is there any such animal in Excel?

BTW, I know about the list box. But, it's too limiting for this need.

Thanks.

 

[davesexcel]

Excel has a ComboBox as well. From the Formsd Tool Bar or the Controls Tool Bar