Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to call a method in thisWorkbook from a module in Excel VBA?

Tags:

excel

vba

I have a method in thisWorkbook.

I want to call it from an other excel vba module, what's the exact syntax ?

like image 637
user310291 Avatar asked Jun 07 '11 19:06

user310291

1 Answers

ThisWorkbook.MethodName

Intellisense won't show it though.

like image 162
GSerg Avatar answered Oct 20 '22 04:10

GSerg
Sign in to Comment

Related questions

Copy selected rows twice
Regular Expressions matching difficulty
Snipping Tool does not start a snip while running Excel Macro?
Combine list and custom formula data validation in one cell within excel without vba
excel nuget package for .net core [duplicate]
Can't use GBP (£) symbol in VBA
EPPLUS adding comment results error opening excel file
Are XLSX files UTF-8 encoded by definition?
Unable to scroll a split screen of a webpage
Reading Excel file without hidden columns in Python using Pandas or other modules
How to convert 32-bit excel VBA code to run on 64-bit excel?
readxl::read_xls returns "libxls error: Unable to open file"
Writing Pandas DataFrame to Excel: How to auto-adjust column widths
best way to programmatically modify excel spreadsheets
Using Excel sheet as a template vs. a "real" Excel template in OpenXML
VBA Tab Key putting actual Tab Value in Text Box instead of navigating to next control
Python win32com opening Excel with Bloomberg plugin
Is there a way to force Microsoft.Jet.OLEDB to get date Columns in MM/DD/YYYY format from Excel?
Does Excel have any map or select functions?
XLAM / XLA Addins: is there a better way?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!