Need an OFFSET for Checkboxes

[JTL9IRON]

I think this pretty simple but I just can't get it right.

I have several checkboxes on a userform that translates a value to cells on the spreadsheet starting in cell B1, C1, D1, E1...etc.

If CheckBox1.Value = True Then
Range("B1").Value = "1"

I have a command button asking if you want to enter another person choices (I have a text box putting the person name in cell A1)

When the command button is clicked I have all the checkboxes value's changed to FALSE and I clear the text box with the name and move the active cell 1 row down, which when I enter the new name it fills in in cell
A2.

TextBox1.SetFocus
Application.Goto Reference:="R[1]C[]"
TextBox1.Text = ""

The problem when I start checking the checkboxes they over right the info already in cells B1, C1, D1..etc.

How do I get the checkboxes to move down one row? Offset?

You help will be appreciated
James

 

[erik.van.geit]

Hello, JTL9IRON
Welcome to the Board !!!!!

perhaps you can try this
it would at least be an idea to start with

If CheckBox1.Value = True Then
Range("B" & ActiveCell.Row).Value = "1"

but this would rely on the activecell which can easily been changed
instead of activecell you could use a counter
this on top of a "normal" module

Publice counter As Long

you ccommand button code could have

counter = counter + 1
'OR
counter : ACtiveCell.Row

checkbox code

If CheckBox1.Value = True Then
Range("B" & counter).Value = "1"

kind regards,
Erik

 

[JTL9IRON]

That's It!! Works perfect, Thanks