Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CheckBox data copy into sheet.
I have created a 3 user box with one textbox and two
CheckBox in each userform. In userform1 if i type in textbox "01" it should check, checkBox one. & 02 it should check, checkBox Two. and than it should go to 2nd userform and work same as userform1. and goto 3ed usefrom and work same. but if user type out of 01 or 02 in any userform it should goto next userform. in userfrom1 checkBox1 name is White in userfrom1 checkBox2 name is Black in userfrom2 checkBox1 name is Pan in userfrom2 checkBox2 name is Ink-Pan in userfrom3 checkBox1 name is Refill in userfrom3 checkBox2 name is Fill and after that it should copy data from all 3 userform checkbox which is not check into sheet1. If user have type in userfrom1 textbox "01" it should copy "02" checkbox into sheet1. like A B C 1 userfrom1 Userfrom2 Userfrom3 2 Black Pan Fill 3 is any one can help me plz. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
checkbox, then taking information from one sheet to another sheet | Excel Worksheet Functions | |||
copy data of two cells from Sheet 2 into one cell in Sheet 1 | Excel Worksheet Functions | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions |