Filling up ActiveX Checkboxes code dynamically

jan šifalda 1 Reputation point
2021-11-30T06:32:47.783+00:00

Hello Microsoft forums,

right now i have a simple VBA code making my ActiveX checkboxes to fill up todays date to the right cell of the checkbox if checked and leave the cell to the right blank if unchecked.

153545-vystrizek.png

Is there a way to write code that would fill up code to all present checkboxes on the sheet that would do the same thing if checked or unchecked?

The main three issues I have with programming this is:

  1. I need to find the right cell from a Checkbox but I am not sure if there is a property of that checkbox that would do that for me.
  2. I need to make an intelling for cycle that would code all Checkbox subs code for me.
  3. VBA is a new thing for me so programming anything is tough for me haha.

Is anyone willing to help?

Microsoft 365 and Office | Development | Other
0 comments No comments
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.