Use excel form Checkbox and tweak macro to suit.

Hi

I have a set of sheets that I indicate items to be processed by a macro by inputting 'Y' into the cell.

I would like to use the form 'Checkbox' which will be quicker/easier for me to select/deselect as required. However I need help to edit my macro to suit.

The lines in my macro which see the 'Y' is;

For i = 8 To 43
If UCase(sh1.Cells(i, 35)) = "Y" Then
r = r + 1
If r > 4 Then
r = 1
c = c + 1
End If

Please see my attached sample.

Thanks

Hi, thanks. Sorry for my ignorance but do I just replace this line with your code?

If UCase(sh1.Cells(i, 35)) = "Y" Then

Hi Sorry for delay in replying after you took the trouble to respond...

Ok, I have a macro which looks in a table and places the data into a format for printing selected records into a A4 template. Currently I input "Y" into a cell at the front of the table so the macro includes that row of data in the results. If the checkbox is checked I want the macro to run on that row of data.

If the checkbox is not checked, I want the macro to ignore that row (i.e. at present when cell is left blank). The macro runs on the active sheet, i.e. I can run it from any of 20 different worksheets.

Thanks