Thread: How do I create a list of options with only one being selectable?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
  
Posts: 3,355
Default How do I create a list of options with only one being selectable?
I think what you want is a data validation list. This should help you

http://www.contextures.com/xlDataVal01.html

"Quincy Jones" wrote:

I am trying to create an invoice template with selectable options on the
workpage. The selections are for different types of credit cards and I want
only one card to be selected at a time in order to stop multiple cards being
displayed as selected on a single invoice.
Reply With QuoteReply With Quote