Can a function I define in a Module be called from a UserForm if they are both in the same workbook? If so, what is the syntax?
Can a function I define in a Module be called from a UserForm if they are both in the same workbook? If so, what is the syntax?
Reality is stranger than fiction.
I figured it out on my own, thanks for the help.
Just for anyone else with this question:
Calling a function in a module from a UserForm is just like calling any other function.
In the Module:
Would be referenced in the UserForm Code like this![]()
Public myFunc(Number As Single) Dim N Set N=Number myFunc=N*5 End Function
![]()
myFunc number OR Call myFunc(number)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks