Call sub from multiple worksheets

[Peppermint Pizza]

Hi,

I'm new to VBA. I'm trying to call a Sub from two different worksheets of the same workbook, but I'm getting an error. Here's what I have.

In Modules -> Module1 I have:

Public Sub ABC()
  MsgBox "You are here"
End Sub

In Microsoft Excel Objects -> Sheet1 I have:

Public Sub CommandButton1_Click()
Call ABC
End Sub

In Microsoft Excel Objects -> Sheet2 I have:

Public Sub CommandButton1_Click()
Call ABC
End Sub

When I click the button while on Sheet 1, it works. When I click the button while on Sheet 2, I get "Compile error: Sub or function not defined." Is there a way to get this to work? Thanks!

[BadlySpelledBuoy]

Hi and welcome to the forum

Could you attach the file so we can see it in context? Easier to diagnose these issues when we can poke around the file, especially when there looks to be little wrong with the code example above.

EDIT:
Attached is a file I set up exactly as you describe in your post, and all seems to work fine for me...

BSB

[Peppermint Pizza]

Thank you, BadlySpelledBuoy. I figured out the problem. It was a typo. The original code used a name other than ABC, and there was a typo on Sheet 2. Once I knew from your reply that this should work, I was able to find the problem.

[BadlySpelledBuoy]

Glad I could help point you toward the issue, and happy you managed to resolve it

BSB