I have placed a command button on a spreadsheet (Sheet1). In the click
event I call a user defined, public function that I created and placed in
the ThisWorkbook module. When I click on the command button I get the
error: Sub or Function not defined.

The function is public and there are no spelling errors. What am I doing
wrong?

Thanks.

Could you post an example of your code, perhaps?

"q" wrote:

I have placed a command button on a spreadsheet (Sheet1). In the click
event I call a user defined, public function that I created and placed in
the ThisWorkbook module. When I click on the command button I get the
error: Sub or Function not defined.

The function is public and there are no spelling errors. What am I doing
wrong?

Thanks.

Sure. Here is the code. In the Sheet1 module I have this:
------------------------------------
Private Sub cmdStart_Click()
Dim bSuccess As Boolean

bSuccess = OpenMessageTable()

End Sub
-------------------------------------

In the ThisWorkbook module I have this:
---------------------------------------------------
Public Function OpenMessageTable() As Boolean

(code omitted)

End Function
----------------------------------------------


"bigwheel" wrote in message
...
Could you post an example of your code, perhaps?

"q" wrote:

I have placed a command button on a spreadsheet (Sheet1). In the click
event I call a user defined, public function that I created and placed in
the ThisWorkbook module. When I click on the command button I get the
error: Sub or Function not defined.

The function is public and there are no spelling errors. What am I doing
wrong?

Thanks.

Try adding a module and putting the Function code in that

"q" wrote:

Sure. Here is the code. In the Sheet1 module I have this:
------------------------------------
Private Sub cmdStart_Click()
Dim bSuccess As Boolean

bSuccess = OpenMessageTable()

End Sub
-------------------------------------

In the ThisWorkbook module I have this:
---------------------------------------------------
Public Function OpenMessageTable() As Boolean

(code omitted)

End Function
----------------------------------------------


"bigwheel" wrote in message
...
Could you post an example of your code, perhaps?

"q" wrote:

I have placed a command button on a spreadsheet (Sheet1). In the click
event I call a user defined, public function that I created and placed in
the ThisWorkbook module. When I click on the command button I get the
error: Sub or Function not defined.

The function is public and there are no spelling errors. What am I doing
wrong?

Thanks.