W
WTG
I know I've asked alot already, and I really am greatful for all the
help. I'd like to promise This is the last time, but I can't... this
is a big project for me and being a newbe to this vba and excel for
that matter I'll most likely be bothering you guys again....Sorry
But I am learning...........
"LOOK BOB I ONLY POSTED IN THE PROGRAMMING GROUP "
Thanks again for all the help you have all given me so far and yet to
come
Here's my new problem
I have a user form with two combo boxes.
Combo box 1 reads EmpData!A1:A100
Combo Box 2 reads EmpData!B1:B100
Then a Cmd Button
I have two work sheets one with data and one with a blank form to be
printed.
I need to be able to pick either a empolyee Number (Combo box 1) or a
Employee Name (Combo Box 2) And then click on the Command button and
have the Excel find the matching row and then copy the cells from the
row in the Empdata worksheet the Proper cell in the EmpPrt worksheet.
ie. Combo Box 1 = 4500
find the cell between A1 and A100 that matches 4500 ( Say A49)
Then copy EmpData!A49 to EmpPrt!D10
Then EmpData!b49 to EmpPrt!k5
Then EmpData!c49 to EmpPrt!A25
ect........
Then Print the Page and return it to a Blank Form.
I tried using a marco, but it's long and the command button doesn't
always run it...
Thanks for the help
Wally.
help. I'd like to promise This is the last time, but I can't... this
is a big project for me and being a newbe to this vba and excel for
that matter I'll most likely be bothering you guys again....Sorry
But I am learning...........
"LOOK BOB I ONLY POSTED IN THE PROGRAMMING GROUP "
Thanks again for all the help you have all given me so far and yet to
come
Here's my new problem
I have a user form with two combo boxes.
Combo box 1 reads EmpData!A1:A100
Combo Box 2 reads EmpData!B1:B100
Then a Cmd Button
I have two work sheets one with data and one with a blank form to be
printed.
I need to be able to pick either a empolyee Number (Combo box 1) or a
Employee Name (Combo Box 2) And then click on the Command button and
have the Excel find the matching row and then copy the cells from the
row in the Empdata worksheet the Proper cell in the EmpPrt worksheet.
ie. Combo Box 1 = 4500
find the cell between A1 and A100 that matches 4500 ( Say A49)
Then copy EmpData!A49 to EmpPrt!D10
Then EmpData!b49 to EmpPrt!k5
Then EmpData!c49 to EmpPrt!A25
ect........
Then Print the Page and return it to a Blank Form.
I tried using a marco, but it's long and the command button doesn't
always run it...
Thanks for the help
Wally.