Command Button to return a default text

[ellehcer08]

Hi! I need to know when the command button is clicked, it will return a specific text or number... Like when I need to click "RESET BUTTON", it will clear the contents is the given range with this code:

Private Sub CommandButton1_Click()
Range("c8:c42").ClearContents
End Sub

But what will be the code if I want to clear a certain range of cells and return a default number "1".
Please help, I'm really confuse with the codes.

And also, if I am using a textbox, and I want to put the number there, and I want to clear that too, what will be the code?

Thanks a lot... Hope someone will help me on this..

 

[VoG]

Do you mean?

Private Sub CommandButton1_Click()
Range("c8:c42").Value = 1
End Sub

 

[ellehcer08]

Do you mean?

Private Sub CommandButton1_Click()
Range("c8:c42").Value = 1
End Sub

yup! exactly what i was looking for... thanks a lot!
but if i am using a textbox, how can i clear that up and can i use the number in that box for a formula in a cell?