ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   check box (https://www.excelbanter.com/new-users-excel/169007-check-box.html)

neilb514

check box
 
hi
I have six checkboxes in a spreadsheet. Only one can be checked at any one
time. ie If checkbox one is checked and i need to change to checkbox two can
checkbox one be automatically unchecked.
Many thanks

David Heaton

check box
 
Hi,
your best bet would be to change the checkboxes to option boxes as these
only allow to be selected at a time

hth

David

"neilb514" wrote in message
...
hi
I have six checkboxes in a spreadsheet. Only one can be checked at any one
time. ie If checkbox one is checked and i need to change to checkbox two
can
checkbox one be automatically unchecked.
Many thanks



neilb514

check box
 


"David Heaton" wrote:

Hi,
your best bet would be to change the checkboxes to option boxes as these
only allow to be selected at a time

hth
thank you perfect...
David

"neilb514" wrote in message
...
hi
I have six checkboxes in a spreadsheet. Only one can be checked at any one
time. ie If checkbox one is checked and i need to change to checkbox two
can
checkbox one be automatically unchecked.
Many thanks



David Heaton

check box
 
thanks for the feedback


"neilb514" wrote in message
...


"David Heaton" wrote:

Hi,
your best bet would be to change the checkboxes to option boxes as these
only allow to be selected at a time

hth
thank you perfect...
David

"neilb514" wrote in message
...
hi
I have six checkboxes in a spreadsheet. Only one can be checked at any
one
time. ie If checkbox one is checked and i need to change to checkbox
two
can
checkbox one be automatically unchecked.
Many thanks





All times are GMT +1. The time now is 01:11 PM.

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