combo box with reference name on the worksheet

Hi All,
i need help with the vba code and the example file.
i have the excel sheet name"person" in a2:a100 are the name group1 , in b2:b200 are the name of group2 and in c2:c500 are the name of group3

I try to create the userform with the "ok"button. the userform have the objects of 3 textboxes and 3 combo boxes.
the first txt.box is alway show the date time value now()
the second txt.box is for user to enter the number of data. and another txt.box is for user enter some text.
but 3 comoboxes allow for select the name from the sheet"name"
group1,2,3

when the user enter all data in 3 textboxes and 3 combo Box. when all data enter and cliked "Ok" it be the sheet name"sheet1 " in cell a4 ,b4,c4,d4,e4,f4
and the next enter if have all data entry , will in the next row
but if no data to enter . when click "ok" button must show the msg."please enter data"

Originally Posted by pichai

Hi All,
i need help with the vba code and the example file.
i have the excel sheet name"person" in a2:a100 are the name group1 , in b2:b200 are the name of group2 and in c2:c500 are the name of group3

I try to create the userform with the "ok"button. the userform have the objects of 3 textboxes and 3 combo boxes.
the first txt.box is alway show the date time value now()
the second txt.box is for user to enter the number of data. and another txt.box is for user enter some text.
but 3 comoboxes allow for select the name from the sheet"name"
group1,2,3

when the user enter all data in 3 textboxes and 3 combo Box. when all data enter and cliked "Ok" it be the sheet name"sheet1 " in cell a4 ,b4,c4,d4,e4,f4
and the next enter if have all data entry , will in the next row
but if no data to enter . when click "ok" button must show the msg."please enter data"

Hi pichai,
Let's see the workbook.....