Using userform to input data

Hello SoCalRizzy,

Which cells will the TextBox data be updating? Column "B"?

Sincerely,
Leith Ross

Hello SoCalRizzy,

I added code to the UserForm to copy the data from the TextBoxes to the worksheet cells in column "B". Not sure if I got all the percentages and dollar amounts in the right place, but it is a start. The data is transfered after the pressing enter, instead of using the update button. This want to change this, let me know.

Sincerely,
Leith Ross

This is wonderful so far! I was hoping I would be able to figure it out now by looking at the code, but it's still somewhat confusing. How hard is it to have the "Cancel" and "Update" buttons work?

Hello SoCalRizzy,

Do you want the the "Cancel" button to close the form? Do You want to "Update" when the button is pressed rather than updating when a entry is made?

Sincerely,
Leith Ross

Yes, the cancel button should just cancel all inputs and close the form. The "update" button should update the cells with what was entered and then close the box. Thank you so much! This has been a huge help!

Hello SoCalRizzy,

I made the changes to the attached workbook. Let me know if you need anything else.

Sincerely,
Leith Ross

This is awesome! Thank you so much for your help! I can definitely use this and build upon it.

Now, related to this worksheet. I know there's a way to password protect the sheet as well as hide that specific worksheet. But I don't want people to be able to unhide the sheet. Is that possible?