ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   is it possible to insert checkboxes in an excel spreadsheet? (https://www.excelbanter.com/excel-discussion-misc-queries/16162-possible-insert-checkboxes-excel-spreadsheet.html)

analiese f

is it possible to insert checkboxes in an excel spreadsheet?
 
I am trying to track the status of jobs using an excel spreadsheet, and I'm
looking for an easy way to select between several options I've placed in the
spreadsheet. It would be great if I can use checkboxes so that users can
highlight as many options as relevant, but I'm not sure if this is possible.
Does anyone know how to do this? And if not can anyone offer another
solution??
Thanks

Earl Kiosterud

There is a check box in the Forms Toolbar (View - Toolbars). You link them
to a cell with Format control - Control tab, then examine the cell with your
formulas or macros. There is a check box in the Controls toolbox. More
functional. Use either Properties (right click the check box while in
Design Mode, or write VBA to respond to the check box.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"analiese f" wrote in message
...
I am trying to track the status of jobs using an excel spreadsheet, and I'm
looking for an easy way to select between several options I've placed in
the
spreadsheet. It would be great if I can use checkboxes so that users can
highlight as many options as relevant, but I'm not sure if this is
possible.
Does anyone know how to do this? And if not can anyone offer another
solution??
Thanks





All times are GMT +1. The time now is 07:17 AM.

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