User Form Update

Hello,

I have attached a spreadsheet that is used to calculate pay bonuses for employees, and the data is programmed to appear on the Month Review tab. I want a user form to appear when the spreadsheet is first opened, and this would allow the operator to input monthly sales and to select the current month from a drop-down list.

I have started the formatting of this user form in VBA, but I am unsure of how to program it and make it update the relevant cells. Can someone help me to set up the VBA form so that the monthly sales figure is updated onto cell B2, and have a drop-down menu on the user form with all the months of the year which will update cell E1??

Thanks,
Yorke

Thanks a bunch!

Is it possible that when "submit" is pressed on the user form, it then closes?