VBA & Macro Problems

How to Create a Dynamic Excel Check-Off List Without VBA

Phi Hung Vo Oct 10, 2026 868 views

Question details

The user is looking for a collaborative, browser-compatible way to mark items complete in a dynamic Excel list stored on SharePoint without relying on VBA.

How to Create a Dynamic Excel Check-Off List Without VBA

Product: Excel
Device & OS: not provided
Scenario: Multiple users need to interact with a dynamic checklist simultaneously via a web browser using an Excel workbook stored on SharePoint.
Observed behavior: Traditional VBA macros and embedded interactive controls are not fully supported or interactive in Excel for the Web multi-user environments.

Before you start

Ensure you are logged into your Microsoft 365 account with access to SharePoint or OneDrive, and verify that your team has permissions to access Microsoft Forms if you plan to use it for data collection.

Solution 1Recommended

Use Microsoft Forms Alongside Excel for the Web

Because VBA is unsupported in the web browser, linking a Microsoft Form to your Excel file is the most reliable way to collect checklist data collaboratively on SharePoint.

Interactive controls like standard checkboxes from the Developer tab do not work properly when a workbook is being edited simultaneously by multiple users in Excel for the Web. Microsoft Forms offers a user-friendly and fully web-compatible alternative.

Create a New Form from Excel Online

Open your Excel workbook stored on SharePoint in Excel for the Web. Navigate to the 'Insert' tab and click on 'Forms', then select 'New Form'.

Add Checkbox Questions

In the new Microsoft Form window that opens, add 'Choice' questions. Enable the 'Multiple answers' toggle to change the layout to checkboxes for your task list items.

Sync and View Responses

As users fill out the Form, their checked items and submission statuses will automatically sync back into a new dedicated worksheet within your SharePoint Excel file.

Share the Form

Click 'Collect responses' in Microsoft Forms to generate a shareable link. Distribute this link to your team so they can easily complete the checklist from any browser.

Use Microsoft Forms Alongside Excel for the Web

Separation of Input and Display: Using this method separates the data entry (Forms) from the data storage (Excel), which eliminates conflicts that occur when multiple people edit the same interactive spreadsheet cells.

Solution 2

Use Data Validation Dropdowns for In-Cell Tracking

If you want to keep the interaction entirely inside the Excel grid without VBA or external forms, use Data Validation dropdown lists.

Create Checklists Easily with WPS Spreadsheet

Create and Share Dynamic Checklists with WPS Office

WPS Spreadsheet makes it incredibly simple to insert interactive checkboxes directly into your cells without writing a single line of VBA code. Easily track tasks, collaborate effectively, and save your work in standard Excel formats.

1. Open your Document: Launch WPS Spreadsheet and create a new task list or open your existing .xlsx document.
2. Select the Target Cells: Highlight the empty cells next to your task items where you want the checkboxes to appear.
3. Insert Checkboxes: Navigate to the 'Insert' tab on the top ribbon and click on 'Check Box'. Interactive checkboxes will be inserted directly into the selected cells.
4. Save and Share: Save your file in standard .xlsx format. You can now share it with your team, allowing them to easily tick off completed items.

Insert native cell checkboxes with a single clickFully compatible with Microsoft Excel (.xlsx) formatsLightweight, fast, and completely free to useBuilt-in collaboration tools for seamless team sharing

Frequently Asked Questions

Can I run VBA macros in Excel for the Web?

No, Excel for the Web does not support running VBA macros. If your checklist relies on VBA to function, you must either open the workbook in the desktop version of Excel or use a web-safe alternative like Microsoft Forms or native Data Validation.

Are Developer tab form controls compatible with Excel Online?

Legacy ActiveX controls and standard Form Controls inserted via the Developer tab are not interactive in Excel for the Web. They may display as static objects or fail to render properly, which is why alternative tracking methods are required for SharePoint multi-user scenarios.

How do I link a Microsoft Form to an existing Excel file?

To link a form to an existing Excel file on SharePoint or OneDrive, open the Excel file in your browser, go to 'Insert' > 'Forms', and click 'New Form'. This creates a Microsoft Form that directly outputs response data into a new worksheet inside that specific workbook.

Excel & Data Problems