ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I create a list of options with only one being selectable? (https://www.excelbanter.com/excel-discussion-misc-queries/138237-how-do-i-create-list-options-only-one-being-selectable.html)

Quincy Jones

How do I create a list of options with only one being selectable?
 
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.

Barb Reinhardt

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.



All times are GMT +1. The time now is 03:29 AM.

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