Checkbox.check according to textbox value

I have 10 textbox's numbered (1-10) and 10 checkbox's numbered as well from 1 to 10.

Textbox1 is linked to checkbox1.

Is there a way that when a user inputs anyvalue on textbox the same checkbox number gets value true imediatly after value input.

Like this:
Textbox1 value written is "1º" ---> ACTIVATE TRUE CHECKBOX1
TEXTBOX7 VALUE WRITTEN is "5º" ---> activate true Checkbox5

If any question come up let me know please

Hi, brainzlp

try

Instead of looking for isnumeric, if you can't put 1º 2º as numbers.

Please just tell me how can i analise if NOT EMPTY.

if not empty textbox then same checkbox gets true.

I just need to put true value on checkbox if corresponding textbox number is not empty.

IF textbox1 is empty then checkbox1 empty.
IF textbox2 is not empty then checkbox2 is true

misclick, sorry. ignore this.

Do you have any idea simcode ?

Thanks

Then, that will be easier.

That works perfect.

Can't i have only 1 private sub instead of 10-20 according to the number of textbox's ?

For any change in userform textbox's execute this macro:

Please Login or Register  to view this content.

And instead of putting from 1 to 10, put from the first to the last textbox
Let me know if you can help me out

I think i need to build a class module, to have a list of all textbox, and for each textbox caption number, then checkbox caption number gets true value

Originally Posted by simcode

Yes, if your have a lots of checkboxes to dealwith, building a new class is a good idea.
The simplest class. Improve it if necessary.
try

Your file is working perfectly, even without i understand the code.

I've done earlier 1 myself which works as well... only with Textbox's as class

I tried in my big file and can't put this working. The textbox change value doesn't work properly.

Please check this thread with my problem, i need to be able to put this in the big file with printranges according to each checkbox.

http://www.excelforum.com/excel-prog...ml#post4268543