How to call a private sub in module from userform?
application.run "sub" doesn't seem working
I think that's the point of the sub being private--to prevent external access.
so you mean a private sub can't be called out from diff. module or userform?
As far as I know, yes.
Can you change the sub to "Public"?
Yes, I can but I just want to have one public sub "Main" in the module
Have you tried "Friend"?
Never tried before but it seems very interesting
Thanks for the link
"Friend" is .net not vb6/vba
What is the reason that you want only Sub Main public? When the reason is, that only Main is displayed in listbox with macros, then change your sub to function
yes, that's the reason - I only want to show sub "Main" in the listbox - change sub to the function is another option
Retrieving data ...