ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Call macro in worksheet from userform? (https://www.excelbanter.com/excel-programming/397347-call-macro-worksheet-userform.html)

Ed from AZ

Call macro in worksheet from userform?
 
How do I call and run a macro contained in worksheet code from a
userform button code? I tried variations of
Run wkb("MASTER!SetNewHeader")
but nothing worked.

Ed


Jim Thomlinson

Call macro in worksheet from userform?
 
Is the userform part of the spreadsheet or is it part of an addin or a
seperate spreadsheet? It's hard to tell from your post.
--
HTH...

Jim Thomlinson


"Ed from AZ" wrote:

How do I call and run a macro contained in worksheet code from a
userform button code? I tried variations of
Run wkb("MASTER!SetNewHeader")
but nothing worked.

Ed



Ed from AZ

Call macro in worksheet from userform?
 
Sorry, Jim. The form is in the same workbook as the worksheet and
macro.

Ed


On Sep 12, 11:06 am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
Is the userform part of the spreadsheet or is it part of an addin or a
seperate spreadsheet? It's hard to tell from your post.
--
HTH...

Jim Thomlinson



"Ed from AZ" wrote:
How do I call and run a macro contained in worksheet code from a
userform button code? I tried variations of
Run wkb("MASTER!SetNewHeader")
but nothing worked.


Ed- Hide quoted text -


- Show quoted text -





All times are GMT +1. The time now is 06:19 AM.

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