Macro for pop up box

[ghugill]

Hi

I need the vba code to create a pop up box that displays a summary of the form contents. ie the form is to contain data and I need to display the content of certain cell ie claimant name, salary, month whilst also displaying the content of summed cells ie total overtime & oncall value

Can anyone help?

Thanks
Gavin

[blane245]

Welcome to the forum!

I am sure we can help you out here if you can give us a littel more information. If you can provide a spreadsheet with some dummy data, indicate how you want the macro to know what cells to report on, and what you want the output to look like, we can move forward.

For starters, In VBA, the basic popup is created by the MsgBox command.

[Palmetto]

I think what you are asking for will, possibly, require a custom User Form and a sample workbook.

However, to show a message box that displays the contents of specific cells, here is the basic idea:

Please Login or Register  to view this content.