Greetings,
I have several check boxes I am using on a User Form; they all will have the same code (with the exception of 2 rows). I know I can rewrite the code for each Check Box, but I would like to have the code run using the check box name.
The following is what I am using:
Please Login or Register to view this content.
Hi,
Your question, I won't go into it with too many words.
But What are you really asking?
The 6 lines of code you posted are all for one checkbox so I honestly cannot make heads or tails out of it.
I suggest you rephrase and try to explain it in a such a way that somebody that has no idea of what you are trying to achieve can understand it too.
I'm sure you know what you're asking but it doesn't reflect in the post, and guessing is something I'm not going to do
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Keebellah,
What I would like to do is copy and paste the code for each of the Check Boxes. Having the "Check Box Name" automatically inserting into the code.
Ex:
Private Sub "Check Box Name"_Click ()
If "Check Box Name".Value = True Then Sheet1.Range("G818").Value = "True"
If "Check Box Name".Value = True Then....
End Sub
Okay maybe it's me but what code do you want to copy? I honestly have no idea what your are talking about and what you want to achieve.
Try showing what you have and would you would like to have.
I think a sample with what you have and what you have in mind that you want to achieve will clear the vision.
Right now it's like swimming in murky water with my eyes closed.
And BTW, use code tags to make it readable for the code sections. (like this)
Please Login or Register to view this content.
If it's addin checkbox code on-the-fly using vba, then I suggest you take a look at this link
https://analysistabs.com/vba/add-che...orm-using-vba/
There are quite a few links with sample code to add checkbox code on-the fly using vba, your BFF Google can be a great help
???Originally Posted by brentjohn
Nothing is ever automatic.
Someone must always write something to make this "something" work a little ... or not work ... more than a little...
Please Login or Register to view this content.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
@ mehmetcik
Take a look at this.
Please Login or Register to view this content.
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.
Thanks Bakerman.
Appreciate the lesson.
I am going to have to modify my sample userforms.
No lesson intended at all (as if you need one) but you assigned the activecontrol name to a variable, which is a good thing, but then you did not apply that variable in the rest of your code.
Hello brentjohn,
There is another more advanced method known as Sub-Classing. This involves a Class Module which is used to create new objects in VBA or customize existing objects.
The Sub-Class contains all the features of the base class (The UserForm CheckBox), but has new features added and modifies some existing ones. Thus every instance of this new Sub-Class shares the same code module. A new Sub-Class object is created and linked to each UserForm CheckBox in the UserForm Initialize event. The UserForm code has a Collection of the new Sub-Class objects that keeps them "alive" while the UserForm is open.
Class Module Code for MyCheckBoxClass
Code for UserFormPlease Login or Register to view this content.
ThisWorkbook Code to Run the DemoPlease Login or Register to view this content.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I'd like to point out that the many "=True" in this thread are un-nessesary
does the same asPlease Login or Register to view this content.
(I know, but its a pet peeve of mine.)Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks