when i tick my check box ,5 should come in column h but when i untick it should disapper

[catchnanan]

Dear Friends

i have a form with checkbox
when i tick this check box,5 should appear in the column H after the last used row in the column H , it works well but when i deselect/untick ,again also the number 5 is coming in the next cell of the column H..when i untick the appeared number should actually disappear ,

My macro
Private Sub CheckBox1_Click()
H = Cells(Rows.Count, "H").End(xlUp).Row + 1
Cells(H, 8).Value = 5
End Sub


can you kindly help me...

[stnkynts]

Do you mean this:

Please Login or Register  to view this content.

[catchnanan]

thank u very much sir