Hello All,

I am somewhat new to Excel VBA and have been searching online for help. I have created a UserForm to help with data entry and database control and need some special functions.

I currently have 2 UserForms, one for Employee info (with multipages) and the other for specific qualifications (OQ Tasks) and dates qualified. Both will update the WorkSheet.

The one for employee info has three multipages, one which editing existing data is done. I have a frame group (OQ Tasks) on that page with 16 checkboxes for each task required for that employee. The caption for each checkbox has the Task Number assigned to it. What I want to do is, if the qualification needs to be edited or deleted, then the user will simply click on the task checkbox and another UserForm (OQDate) will open with basic employee information, the task number (from the checkbox) and the date the task qualifcation was completed (if available) or add a date for the task.

The problem I am having now is passing the checkbox caption (which is the task #) to a label caption on the OQDate userform. I've done it for a single checkbox, but I want to do it for any checkbox that is clicked. I've already coded it (using on MouseDown) so that the checkbox value stays the same when clicked (the OQDate userform will update the status). I ran a loop I found online and it shows the last checkbox instead of the one I clicked on.

Also, to keep track of the checkboxes, I've renamed them to ckboxEdit201, ckboxEdit202, ckboxEdit607, etc. The tasks aren't numerically contiguous.
Each one has its own caption property set to the last 3 digits of its name. ie ckboxEdit201 caption is 201.

Is there a way to run an if or select statement to dynamically get the checkbox caption? And would it be placed in the Sub for OnClick or MouseDown? Or would I need to make it a separate Sub and call it in an Event Handler?

So the synopisis would be something like:
UserForm1:Multipage #3(PageEdit):FrameOQ: CkboxEdit201 -> onMouseDown ->Get the CheckBox Caption - pass it through MsgBox confirmation to frmOQDate (other UserForm) label caption. (Do this for any CheckBox when MouseDown).

Thanks in advance for your help!