checkboxs check from textbox

[sd]

i have created a 1 textbox & two checkbox in userform1 &
userfrom2 & userfrom3.

I want if i type in textbox 01 it should check, checkbox1
or 02 it should check checkbox2. Like that in 3 userfrom.
if i type out of 01 or 02 in any userfrom it should go to
next userfrom and after completed all 3 userfroms it
should copy that it should copy all 3 checked data into
sheet.

plz any one can help me.

Sd
..

 

[Tushar Mehta]

I am sure your work makes perfect sense to you, but I am at a complete
loss. If you have multiple userforms that you want code to update, why
have them in the first place? After all the intent of userforms is to
interact with an user!

Similarly, why have a checkbox that is programmatically set based on the
value of a textbox? Just get rid off the checkbox and use the value in
the textbox directly!

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office