userform with lebel name as in sheet1

**pichai** · 01-15-2008, 09:33 AM

Hi, how can i do this solution. i try to create user form with 5 check box.
when the serch button is clicked. the userform will show , and if the sheet1 range a1:a6 have any value.(as MR.A ,MRB ,MRC). it will appear that name in the userform as the lebel .
after that the check box is checked and click "ok". it will run my macro code.
can any one help me with the code to created that userform ??

**Leith Ross** · 01-15-2008, 03:19 PM

Hello pichai,

I add the code below to your workbook which is attached. When the Serch button is clicked, the UserForm loads the labels with the contents of cells A1:A5. If the cell is not empty then the corresponding check box is checked. The Clear Form button clears the check boxes and labels., and the Cancel button closes the form. I wasn't sure what to do with the OK since you didn't have any macro code for it.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**pichai** · 01-16-2008, 10:19 AM

Hi,thank Leith Ross
your code is the wonderful that the best use for me.
i have some more help ,please...me the code
when the "ok" button when is clicked . if the checkbox check true itwill copy the range of a1:g1000 from the sheetname "1" ,if the check box 2 is clicked it will copy range a1:g1000 from the sheetname "2" if the check box 3 is clicked . it will copy the range a1:g1000 from the sheetname "3".....etc.
so , if only checkbox2,4 ,5 is clicked .that the data wil be copy from sheet 2 and 4 and 5 only. and the data of sheet 2 is the beginer with the last row by the sheet4 and 5 . all that data will be copy to sheet name "summary"

and also that ,if all check box is not clicked nothing to be copy to the summary sheet .the msg.show "selected data sheet ,please"

thank ,hopefully help me