Declaring specific userform variables/checkbox

Hello -

I'm fairly new to Excel so forgive me if these are noob questions.

I have a userform which I would not only like to declare variables for, but would also like to state what they stand for. Next, I would like to be able to refer back to them throughout the whole userform based off of Checkbox values. For example in declaring all variables in the userform:

Please Login or Register  to view this content.

Now, if a checkbox's value is true, I would like to make the above variables what they are declared above and place them into a text box. If they are false, I would like to make them blank (Var1 = "" for example). Lastly, when the checkbox value is false, I want to remove the specific variable's text out of the text box (making it ""). I have attempted to do this by using the following:

Please Login or Register  to view this content.

It's kind of like an on/off switch code for each checkbox. Place the veriable's text in the text box if checked, remove it (only that text box's verbiage) if unchecked, but leave all other checkbox verbiage in the text box.


It is going to be labor intensive if I have to create 10 different checkbox true/false subs, on 7 different tabs, in this userform. From what I see, I am going to have to create a sub for every checkbox and include similar code, like the code above, to make this work with every single variable and checkbox. There is going to be 1 variable for every checkbox...for a total of 10 checkboxes per tab, 1 text box per tab, and about 7 tabs.

Is there an easier way? Am I doing this completely wrong? Any help is greatly appreciated. Thank you.

What's the purpose of this?

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

I have attached a dummy workbook for how I would like this to work. The user can check, uncheck, and then check, and the text stacks. What I want is for the checkbox's text to be removed when it is unchecked, and placed in the text box when checked. "Stacking" text is also a normal part of how this is going to work.

Thanks again!

I keep trying to come up with the code and I'm not getting the on-off results I want. Also, I keep getting "nothing but comments can appear after End Sub or End Property" error. There isn't anything after it in the sub. So frustrating.

I think this might be something like what you want

Please Login or Register  to view this content.

I do not understand what the "Me" does within VBA in excel. Is

In ThisWorkbook module, Me refers to the workbook in which the code appears (i.e., ThisWorkbook)

In a worksheet module, Me refers to the associated worksheet (and the worksheet is the default reference for range references)

In a forms module, Me refers to the form

Thank you so much. The above code is working as I intend it to work.

Now this may be a mooching question, but I do not understand part of the code. The fact that "it works" is not good enough for me. I like to understand "why" it works so I can use it for other forms and situations in the future.

Would you mind explaining, or pointing me to a link for:

Me and Not Me
addVar and how it works with "i"

Lastly, when I want to close a userform, is it ok to use "userform.Hide" to close it, or is it best to use "Unload Me"?

EDIT: I posted after the above "Me" explanation. My confusion with the explanation is why do I have to declare "Me" for VBA to know I'm referring to that specific userform? I figure it is intelligent enough to understand the code I'm creating only corresponds to that particular form.

You don't specifically need to use Me,it's just a good practise.

The addVar is just a Procedure that works within the UserForm to add your value to the TextBox,the i is declared as an integer within the brackets of the Procedure. The value for i is added when the Procedure is called by selecting the CheckBox.

You can Hide a form.

Hiding a form maintains the current contents when it is subsequently redisplayed in the same Excel session. Unloading resets it to its design-time values.

What's ** for?

The code didn't error in your test file

If you have a problem then attach the workbook