ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help with Menus (https://www.excelbanter.com/excel-programming/296000-help-menus.html)

David Joseph

Help with Menus
 
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



Bob Phillips[_6_]

Help with Menus
 
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






All times are GMT +1. The time now is 04:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com