excel vba - combobox dropdown

[chief]

i am setting up an invoicing program in excel. i have set up toggl
buttons you can click on for purchasing purposes. i want to set it u
so that when someone clicks on the credit card button, a drop down lis
will appear next to it and they will be able to choose which cc th
customer is using. furthermore upon selecting the cc, the outline o
the box will disappear and display only the text in the cell. doe
that make sense

 

[Dave Peterson]

It sounds like you could use Data|Validation.

You can visit Debra Dalgleish's site for a nice overview:
http://www.contextures.com/xlDataVal01.html

 

[chief]

thanks that worked grea