private sub checkbox2_click()

[kevin lazell]

hi everyone
i have set up a checkbox that when clicked goes into a code thus

private sub checkbox2_click()
private sub worksheet_calculate()
i get ambiguous name error
iread the help file that came up but i did not understand it
can someone help please

 

[Artemus]

What are you trying to do in your routine?

Every subroutine (macro) starts with SUB and must end with END SUB

If you are trying to make the current workbook calculate, you could try:

Private Sub checkbox2_click()
Application.Calculate
End Sub

It appears that you inserted the start of another procedure (worksheet_calculate) inside the first procedure.

 

[kevin lazell]

HI ARTEMUS
thanks a lot for your reply it worked a dream
perhaps you should have written the help files
i found it was all gobble-de-gook to me
thanks again
kevin