hello,

Ive been searching on this for awhile now... im not very intelligent when it comes to VBA or Macros but this is what im trying to do if someone can help me please.

I have multiple cells for example s7:s20. I would like for a pop box to open with 5 blank boxes that my employees can fill out when they click any cell in column "S". lets say they click "s7" the popup box appears and they fill the information. After they have filled out the information they would click on a "done" box in that popup that would calculate the numbers with a formula I have that has been entered. that number will fill in the same cell(s7) they clicked on.

I hope ive explained this in the best way.