The variable "Boks1" works great when submitting data Cmddata1 (green) but does not work in Userform_initialize() (red). Why?
If I replace boks1 in Userform_initialize() with 19 it does work.
Attached to a button in my worksheet:
My UserForm looks like this:
Please Login or Register to view this content.
Please Login or Register to view this content.
Declare it as Global
Elegant Simplicity............. Not Always
Well, boks1 is declared as Public - isn't that enough? (Top of userform)
And it won't let me change Public to Global:
--------------
Constants, fixed-length strings, arrays, user-defined types, and Declare statements not allowed as Public members of an object module
-----------------
I'm doing something wrong, I know, but I just don't know what :-)
Put it in a code module as a Global and then you can share it between the worksheets and the userform.
Last edited by AndyLitch; 06-02-2013 at 08:19 AM.
Do you mean like this? I believe this is the Code Module. It won't work - When I click the button it marks ".boks1 =" and sais "Method or data member not found"
Yes, I'm a newbie :-)Please Login or Register to view this content.
The problem is that the initialize event is fired before the value is assigned to the variable.
If you not declare it in a standard code module as AndyLitch suggests you will need to create your own initializing event in order to set things up with correct values befoew the use form is shownPlease Login or Register to view this content.
userform code
module codePlease Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks