ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to make a checkbox usable for users to "check" it? (https://www.excelbanter.com/excel-discussion-misc-queries/118446-how-make-checkbox-usable-users-check.html)

Brit

how to make a checkbox usable for users to "check" it?
 
I have placed a "check box" into an Excel form, but it always comes up for
editing / formatting instead of placing a check into it. How do I resolve
this issue.

Mike Rogers

how to make a checkbox usable for users to "check" it?
 
Brit

Sounds likw you are still in "Design Mode"
Go to to "view" "toolbars" "control toolbox" and "exit design mode".

Hope this Helps

Mike Rogers

"Brit" wrote:

I have placed a "check box" into an Excel form, but it always comes up for
editing / formatting instead of placing a check into it. How do I resolve
this issue.


Brit

how to make a checkbox usable for users to "check" it?
 
Hi Mike, thanks for that. I have exited design mode but I still cant get it
to apply a check in there. It selects it as though to edit it. I have it in
a cell that is not protected and wish for others to click it to place a check
in there to show they have completed a required task. Any ideas?
Thanks

"Mike Rogers" wrote:

Brit

Sounds likw you are still in "Design Mode"
Go to to "view" "toolbars" "control toolbox" and "exit design mode".

Hope this Helps

Mike Rogers

"Brit" wrote:

I have placed a "check box" into an Excel form, but it always comes up for
editing / formatting instead of placing a check into it. How do I resolve
this issue.


Mike Rogers

how to make a checkbox usable for users to "check" it?
 
Brit

Tell me how you placed your checkbox, was it from the "forms" tool bar or
the "control tool box" toolbar? I just used both and from the "control
toolbox" I had to NOT be in design mode and from the "forms" it did not
matter, both worked as they should have. How many of these check boxes do you
need and are they all in one column?

"Brit" wrote:

Hi Mike, thanks for that. I have exited design mode but I still cant get it
to apply a check in there. It selects it as though to edit it. I have it in
a cell that is not protected and wish for others to click it to place a check
in there to show they have completed a required task. Any ideas?
Thanks

"Mike Rogers" wrote:

Brit

Sounds likw you are still in "Design Mode"
Go to to "view" "toolbars" "control toolbox" and "exit design mode".

Hope this Helps

Mike Rogers

"Brit" wrote:

I have placed a "check box" into an Excel form, but it always comes up for
editing / formatting instead of placing a check into it. How do I resolve
this issue.



All times are GMT +1. The time now is 06:59 PM.

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