Forum Discussion
Solved
Inserting a checkbox into Excel Online
Hello, is there any way to insert a checkmark box in the Online version of Excel, which doesn't have access to the Developer tab? Thank you!
Ravindu94 Had a quick look at your set of macros. I suspect that many of them are straight recordings without any clean-up performed. I notice numerous unnecessary scroll commands, select something, do nothing, select something else, format something and then format the same selection again etc. It really needs cleaning-up. Can't really test any of it, as you link to files on your own system.
The button on your first sheet starts up a sub called "CommandButton1_Click()". I've inserted the code I suggested in my previous post. You'll need to copy the Statusbar piece before each of the following calls and increase the step number by one (I've done two for you). Note that the Statusbar gives visual feedback in the bottom left-hand side of the screen.
Private Sub CommandButton1_Click() Application.Screenupdating = False GetFile1 Application.Statusbar = "Step 1 of 22 completed" Macro1 Application.Statusbar = "Step 2 of 22 completed" GetFile2 Macro2 Macro3 DeleteBlankRows Macro4 Macro5 Macro6 Macro7 Macro8 Macro10 Macro11 GetFile2 Macronext1 Macronext2 Macronext3 Macro1next Macro2next Macro3next Macro4next summery Application.Screenupdating = True End SubIf you insist on using a UserForm, use Google to find detailed instructions. It's not something I'm familiar with. Sorry!
I believe the new check boxes, that are more like conditional formats rather than form controls, do work online. On the desktop they are set using
> Insert / Cell Controls / Checkbox
The checkbox appears as formatting within a cell that actually contains TRUE/FALSE. Applying further condition formatting can achieve other effects such as the red/green cells shown in the picture. Clicking on the cell still toggles the setting.
Nope, it's only on Desktop, Beta. Status is in What's New https://techcommunity.microsoft.com/t5/excel-blog/what-s-new-in-excel-january-2024/ba-p/4026581
There must be some logic to that! On the desktop I have the option of using form controls or even VBA events and shapes. It is online that there is a dearth of controls so I had hoped that might be the primary platform targeted .
Who knows what is in background, devil is in the details.
