private sub checkbox2_click()

kevin lazell

Well-known Member
Joined
Jun 2, 2004
Messages
506
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 :confused:
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Artemus

Board Regular
Joined
Dec 30, 2004
Messages
92
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

Well-known Member
Joined
Jun 2, 2004
Messages
506
HI ARTEMUS
thanks a lot for your reply it worked a dream :biggrin:
perhaps you should have written the help files
i found it was all gobble-de-gook to me
thanks again
kevin
 

Forum statistics

Threads
1,136,706
Messages
5,677,309
Members
419,685
Latest member
hennLow

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top