I have a checkbox and multiple textbooks let say about 10.When the checkbox=true , i will be able to write data inside. if checkbox=false, it will be lock. THe code below work when only i click the button. How do i make it work immdiately upon when the checkbox=false?
Please Login or Register to view this content.
Go www.cashcrate.com/3866888 to earn cash online!!!
Last edited by ngkj; 07-17-2012 at 05:16 AM.
Put the code in CheckBox1_Change() instead of CheckBox1_Click.
Welcome to: http://www.exceldigest.com/myblog/
"Excel help for the rest of us"
still the textbox cant be lock upon running
Go www.cashcrate.com/3866888 to earn cash online!!!
Last edited by ngkj; 07-17-2012 at 05:17 AM.
if you use a userform the idea given by se1429 works
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
I am new to this, maybe u wanna take a look at my file.
Go www.cashcrate.com/3866888 to earn cash online!!!
Last edited by ngkj; 07-17-2012 at 05:19 AM.
see if it helps you, please continue with the rest of your textboxes/checkboxes
Please Login or Register to view this content.
Yup! It works! thanksP.S just to ask another thing. If checkbox is not check the data will not be change, how can i do that?
Go www.cashcrate.com/3866888 to earn cash online!!!
Last edited by ngkj; 07-17-2012 at 05:20 AM.
in this case, why you use this code in your first post?!Originally Posted by ngkj
Yup! It works! thanks
Please Login or Register to view this content.
i was new to this so i don't really know, sorry. the error i get was that even thought the checkbox is uncheck the data still change upon clicking the button.
this is me current codes
Please Login or Register to view this content.
Go www.cashcrate.com/3866888 to earn cash online!!!
Last edited by ngkj; 07-17-2012 at 05:21 AM.
no problem at all, we are here to help each other and to learn!
so, please the test file attached, it works for me, if the checkbox is checked you can type in yr textboxes if not...not!
yup! i am a student new to this
Go www.cashcrate.com/3866888 to earn cash online!!!
Last edited by ngkj; 07-17-2012 at 05:21 AM.
are you working in userform, aren't you?
when you display yr userform, the checkbox1 is checked, so you can type/add text in yr textboxes, if checkbox1 is unchecked the textboxes(1...) are locked you can not add/delete anything in them!
yep i know, i wanted to change the data in the worksheet and i solved it! and better ways others than this?
Please Login or Register to view this content.
Go www.cashcrate.com/3866888 to earn cash online!!!
Last edited by ngkj; 07-17-2012 at 05:22 AM.
I do not know, you can try this
and if you want to see in the userform yr values try to add in the userform this codePlease Login or Register to view this content.
just try to play with it
Please Login or Register to view this content.
Thanks! you have been a great help to me!
Go www.cashcrate.com/3866888 to earn cash online!!!
Last edited by ngkj; 07-17-2012 at 05:22 AM.
glad to be of help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks