Pop-up forumla

Originally Posted by adgjqetuo

I'm looking for a sheet that when you open it, a pop-up window comes up with a custom message and an area of text that asks you to enter a number (in my case net sales) then once entered and hit OK, another comes up asking for the Thursdays prediction sales, then another asking for Fridays prediction sales, and another asking Actual beverage sales. Then once all 4 numbers are entered into the prompts, it uses those 4 numbers, does a formula with them, and spits out the total predicted food and beverage for the week.

This is for my work...

Any help would be greatly appreciated!

You can have all four text boxes in a 1 UserForm
Here's one place to learn................that topic is very common
http://www.exceltip.com/st/Create_Us...Excel/629.html