Adding value to cell directly below the checkbox that initiated the userform

Hi

I’m creating an audit form that uses form control checkboxes that initiates a userform for the user to specify the type of error identified.

Attached is the simplified file and what I would like to accomplish is as follows: Userform simplified.xlsm

Currently, Checkbox 1 is linked to Cell B2 and Checkbox 2 is linked to Cell D2

Both checkboxes will load the same userform when checked.

When the “Add Error” is clicked, the VBA code is scripted to search for the next empty row within the range of (B:E) and adds the value in combo box into the 1st column and text in Remarks into 2nd column.

My query is: How should I change the VBA code such that the values are added into the cell directly below the checkbox that initiated the userform?

Meaning, when I add errors with the userform initiated by check box 2, the values from the userform should be added into cell D3 & E3 instead of B3 & C3.

I have many of such checkboxes all over my audit form and manually specifying which cells to add the values is not really feasible.

Thank You

Thanks JasperD

Hi JasperD,

For

Please Login or Register  to view this content.

How can I change the code to make it add the value at the row below the cell that the Checkbox is in automatically instead of entering "3"?

Because my form will have many rows of the checkbox doing the same function.

Thank you

Wow, That's awesome! Works like magic! Thanks Andy Pope!

Would it be troubling to explain what each code does? I'd like to understand the code for my personal development.

Thank you very much!

Hi Andy,

There is a small problem, when the initiated userform is closed via the "cross" instead of using cancel button, error message is prompted.

How do I resolve it?

Thank You.

Hi Andy,

The code works, but the msg box that prompts "error added" is displayed, any way to remove it?

Thanks Alot!

Hi Andy,

The code works, but the msg box that prompts "error added" is displayed, any way to remove it?

Thanks Alot!