David,

I think you want Data Validation. See
http://www.contextures.com/xlDataVal01.html

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"David Joseph" wrote in message
om...
I would like to add a button in a cell when clicked would display data
such
as client names or address...
this would allow less key strokes. all you have to do is choose the
address
and it fills it in. this could be done in several columns.

I am extremely new to macros

how would I accomplish this item and how do I get started

thanks
David Poe