code to record an amount into a table

[chubbychub]

I would like a very simple payroll, I only have 3 people working, so let say I would like to enter the name of employee and enter the amount of money pay for that week (an automatic date) enter into a table , but instead of open a sheet if I can just use a form and use a button to click on it. Please give me a sample or idea on how I can do this. Thank you.

[jeffreybrown]

This tutorial should help get you started.

Build a UserForm for Excel

[chubbychub]

Ok, I have modified the userform to kind of what I want, I want to change each person to have a separate sheet, for example, carlos to have its own sheet, jesus on his own sheet, Charlie on his own sheet. How can I do that? or if someone can help me do that please, please look at attachmemnt.

[xladept]

This works with a sheet for each cboDepartment.Value (it'll install a new sheet)

Please Login or Register  to view this content.

[chubbychub]

That works! thank you ! Xladept and jefreybrown! reputation added.
I have changed as far as I can with the limited knowledge I have, I have created a button in the userform called "Savings". Can someone add the code to add a savings amount entered into the next column? For example, when I click on savings, it will add the amount in column E and the date in column F (of course corresponding to each person), thanks in advance.
please look at attachment.

[xladept]

You're welcome and thanks for the rep!

Maybe:

Please Login or Register  to view this content.

[chubbychub]

Thank you xladept, I have work on it more, and almost done, currently the code adds the name over and over again on columnA, is there a way to change the code to check, if name already on A2 cell, then no need to write the name, Please look at attchament.

[chubbychub]

I think I should close this trhead as my initial problem has been solved and start a new thread. Thank you though xladept.

[xladept]

You're welcome and thanks for the rep!