Msg box displays prematurely; not in sync with the output answer cell

[BGiffin2004]

When the function executes the message box displays the answer in square inches as it should. Though, the output cell D16 (square feet) will not display the answer until AFTER the message box is turned off (or the OK button is pushed.) These two output sources are not in sync. I want the output cell (D16) and the message box to display their respective answers at the same time. How can I get the two in sync? (See attached workbook.) [I am using Windows XP; 32 bit and using Excel 2010]

Please Login or Register  to view this content.

[Leith Ross]

Hello BGiffin2004,

The behaviour you are describing for a message box is normal. This action of not updating the worksheet or allowing the user to change the worksheet until the OK button clicked is known as modal operation.

The only way to "sync" the operation would be to use a UserForm in place of the message box. A UserForm can be displayed modally or not. I have made the need changes to the attached workbook.

[BGiffin2004]

A little late this; but I'm new. - Just got the heads-up on posting the link if I happened to cross-post this post. I posted it also on MREXCEL.COM @ http://www.mrexcel.com/forum/showthread.php?t=592247 This forum here is the original forum I posted to, and will refer readers at MrExcel.com to this site to reply here.

[abousetta]

Earlier when I saw this thread I had the same idea as Leith but I was using a textbox that I inactivated. Leith's approach is better.

Now that I had some time to think about it, there is another simple approach (a worksheet_change).

In a standard module:

Please Login or Register  to view this content.

In Sheet1's code:

Please Login or Register  to view this content.

Hope this helps.

abousetta

[BGiffin2004]

Yes it does help. Thanks so much for helping me out.
Leith; thanks also!