Checkbox VBA or formula Help

[cgi2099]

Hello all,

We are trying to create an excel sheet that is easy to use for people that don't know excel well.

We would like to have a formula or vba code that will add checkboxes to certain cells when a new row is selected within the selected row. If a new row is selected but nothing is entered we would like the check boxes to be remove. But if the new row gets data entered the checkboxes stay the same.

Columns to get checkboxes with new row would be I, L, N, P, & R.

Thank you in advance for any help!
Josh

[6StringJazzer]

I am not a big fan of dynamically created checkboxes on a worksheet. In addition, using this kind of VBA for a user who does not know Excel well could confuse the user, and you have to make sure they understand how to enable macros.

How will these checkboxes be used? That is, once a user checks one, how is that used as some kind of data? Do you also want to link the checkboxes to cells?

An option that works just as well, and is much easier to implement, is to have the user put an X into the cells rather than use checkboxes.

Also, what does "when a new row is selected within the selected row" mean?

To make any progress, regardless of the solution, we'll need a sample workbook. Please see yellow banner at the top of the page.

[cgi2099]

I am not a big fan of dynamically created checkboxes on a worksheet. In addition, using this kind of VBA for a user who does not know Excel well could confuse the user, and you have to make sure they understand how to enable macros.

How will these checkboxes be used? That is, once a user checks one, how is that used as some kind of data? Do you also want to link the checkboxes to cells?

An option that works just as well, and is much easier to implement, is to have the user put an X into the cells rather than use checkboxes.

Also, what does "when a new row is selected within the selected row" mean?

To make any progress, regardless of the solution, we'll need a sample workbook. Please see yellow banner at the top of the page.

Sorry I never replied to this, we ended using a Excel form instead. Thank you so much