I'm trying to create and use a userform to input data into specific cells in a sheet. For instance, if I create the userform with 4 text boxes and I want the user to input numbers into those text boxes that then fill in a hidden sheet.
"Textbox A" = cell A2 on sheet 1
"Textbox B" = cell B2 on sheet 1
etc.
I actually have 8 boxes for the user to input numbers (some are percentages, some are dollar amounts) and then an update button.
How do I do this?
Bookmarks