For the second portion, I'd consider Data|Validation.

You can read Debra Dalgleish's site for info:
http://contextures.com/xlDataVal01.html


AlandAnt wrote:

I have seen a worksheet set up so that when you type text into a cell and hit
enter it appears in another cell on the same worksheet. How do I set this up?

Also, I'm trying to insert a dropdown box with a simple yes or no option
with a large button. The box is almost like a button within the cell. Any
suggestions?

Thanks

--

Dave Peterson