I have a Userform that has a few TextBoxes that paste into specific cells. In that same userform I have 9 CheckBoxes (CheckBox1, CheckBox2, etc...) that need to paste values when checked in the next empty rows in Column A on Sheet2. So CheckBox1, if true, would paste the value "Cal1" in cell A1. CheckBox2 would paste the value "Cal2" in cell A2, and so on.. What code do I need to do this with? I have never used the CheckBoxes and would greatly appreciate some help.
I miss read your requirement, but there is enough here to get you going.
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.
Thank you for the reply, I tried this code but I failed to mention that whatever is checked needs to be pasted into the next empty row. So if CheckBox1 and CheckBox7 are the only ones checked then they need to appear in cell A1 and A2. Also CheckBox1 needs to say Cal 1, CB2 needs to say Cal 2, CB3 Cal3, CB4 DOA1, CB5 DOA2, CB6 HYDRO, CB7 THC HYDRO, CB8 Negative. Sorry for the confusion and i appreciate the help tremendously.
OK#
Try this amended code:
Please Login or Register to view this content.
I keep getting a debug error 13: Type mismatch forPlease Login or Register to view this content.
Are you using Excel 2013?
I get no errors
Is this version working?
Last edited by mehmetcik; 02-11-2015 at 10:54 PM.
Ah i just copied the code into my module again and it works now! Thank you so much for all the help! This helps me tremendously!@
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks