Creating a message box to take an X, Y, Z and perform Sum of Squares
Posted by Joe D on October 11, 2001 12:24 PM
Hello, I would greatly appreciate if anyone could help me out as I am new to Excel and VBA.
I want to create a macro that will generate a message box with the following:
A message saying "Please enter X, Y and Z to calculate Sum of Squares"
In the box there are three "input fields labeled X Y and Z.
After entering the numbers hit a button on the box to do the calculation.
The box should then dissapear and the result should be pasted into Column J. The tricky part is that this could
be run multiple times and I don't want the new info to overwrite the previous info in Column J. It would actually
be best to insert a blank space and then write the new info.
I hope this isn't too confusing and I thank anyone who can help me for their time!!!