ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Calling a Sub created on the fly (https://www.excelbanter.com/excel-programming/445137-calling-sub-created-fly.html)

[email protected]

Calling a Sub created on the fly
 
I can write code to add a code module to a project and place desired code
into that module. However, I cannot call a sub in that module - it fails
at compile time because, at that time, it is undefined.

How can I accomplish this?

I'm sure this question has been answered many times, but I haven't found a
solution. Many thanks for your help.

[email protected]

Calling a Sub created on the fly
 
Application.run "SubName"[,parameters]

On Wed, 23 Nov 2011 09:22:56 -0500, wrote:

I can write code to add a code module to a project and place desired code
into that module. However, I cannot call a sub in that module - it fails
at compile time because, at that time, it is undefined.

How can I accomplish this?

I'm sure this question has been answered many times, but I haven't found a
solution. Many thanks for your help.




All times are GMT +1. The time now is 11:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com