worksheet subroutine causes Compile error: Not found when on User

[Jim Brownson]

Attempts to execute a subroutine (or function) defined on a worksheet module
fail with compile error: sub - function not found. The sub works fine when
called from another worksheet. I open the user form nonmodally to allow
worksheet tasks. I have checked the spelling of the subroutine and it is
defined as Public.
Thanks, Jim

 

[Jim Thomlinson]

Preface the call with a reference to the worksheet where the routine is
stored.

Call Sheets("Sheet1").Myprocedure
or
Call Sheet1.Myprocedure

 

[Jim Brownson]

Works great. I should have though of that, but am following examples in Jeff
Webb & Seve Saunders new book: Programming Excel with vba & .net from
O'rielly- pgs 802+. Their examples show just the sub or function name (not
qualified by the sheet name). Other than this minor problem, great book. Much
Thanks, Jim

 

[Jim Thomlinson]

You do not have to reference a module, but you do neet to explicitly
reference sheets and ThisWorkbook to use their procedures.