Hi Guys,
i am running useform and i want to add counter as global variable to workbook.
i declared counter in userform above:
Please Login or Register to view this content.
but when form is starting counter is always = 0, why ?Please Login or Register to view this content.
How to do this ?
Best wishes,
Jacek
I added in Thisworkbook:
In useform initialize event:Please Login or Register to view this content.
in module :Please Login or Register to view this content.
this is not working.Please Login or Register to view this content.
Please help,
Best,
Jacek
AFAIK, you need to declare public variables (variables that have scope across all modules in a project) in a code module, not an object (workbook, sheet, form, class) module.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Hi.
Because my technique is old fashioned and at times chaotic I resort to carrying the variables between subs.
As per the attached example, I find this easier as I 'glue' my code together with very little forward planning.
Note the variables in the 'Call' statement and in the Module.
torachan.
thank you.AFAIK, you need to declare public variables (variables that have scope across all modules in a project) in a code module, not an object (workbook, sheet, form, class) module.
But idea is to pass thisworkbook variable to form while workbook is opened.
and after restarting form how can i know that form was opened already one time while workbook was starting ?
thank you, this is a good option but the thing what iwant i described above.Hi.
Because my technique is old fashioned and at times chaotic I resort to carrying the variables between subs.
As per the attached example, I find this easier as I 'glue' my code together with very little forward planning.
Note the variables in the 'Call' statement and in the Module.
torachan.
Best,
Jacek
Last edited by jaryszek; 02-23-2019 at 10:24 AM.
As bakerman has said you need to move the variable.
ThisWorkbook should beAnd the module should bePlease Login or Register to view this content.Please Login or Register to view this content.
thank you, now i am understanding
Best,
Jacek
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks