I know to use Active X and buttons to create a counter that when clicked increments by 1 in normal Excel easily enough but excel 365(online) doesn't allow for buttons. Any idea how to create a counter in Excel online?
CodePudding user response:
There are two possible ways for O365 on the web:
- Create a web add-in where you can develop a custom UI (it can be a task pane) with a counter, see Build an Excel task pane add-in.
- Use Office scripts, see https://docs.microsoft.com/en-us/office/dev/scripts/resources/vba-differences for more information.
I suppose web add-ins is the right choice for a custom UI (a task pane).