Dialog Boxess possible

[Guest]

Hi all,

We are trying to work out a profit/loss type of thing with excel and want to
make it easier. Is it possible to have a dialog box open up with various
lines to put information in and then this can go into specific sheets and or
tabs to be able to recalculate totals, rather then having to enter it in each
different sheet/tab?

 

[Dave Peterson]

You could build a userform:
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm

Or maybe a simple version...

Create an "input" worksheet.

Put a nice description in column A and allow the user to enter values in column
B. (You could have warning messages in column C).

Then use a formula in those other sheets to get the data.

if you needed a value from B97 in one of your other worksheets:

=Input!b97

or

=if(input!b97="","",input!b97)

===