Macro to Show/Kill Form Formatted Data Table

Hello Seniors,

Sample workbook in 1997-2003 Excel format with data sample is attached.

There are two worksheets, say, 1) Dashboard, and 2) Flash.

Worksheet "Flash" has formatted Table in Range B1:L8 (tabulation summary), which i want to display in Worksheet "Dashboard", as it it is formatted through USERFORM. Could this be done through taking formatted data table as picture and displayed on Form?

Formatted Table in worksheet.range B1:L8 could be vary in terms of coverage of columns/row, depending on actual data.

A separate button in worksheet Dashboard should be there to close this USERFORM in Dashboard worksheet, which should be 'killed' and not hided.

Good if USERFORM can also be killed using 'ESC' button on KeyBoard

How to do it through VBA macro, so that Formatted Table could be flashed in Form, and can be closed (killed).

Good if custom Title could also be given to Userform as Header taking Input from content of Cell A1.

Data is for DISPLAY only, no further changes.

This doesn't use a UserForm. It copies the table as a picture and shows\hides it on the Dashboard. The picture is also linked to the original table. So if you change something on the table, the picture also changes.

Please Login or Register  to view this content.

Put a White background fill in the Flash table with border lines around each cell. It will look the same as before, but it will no longer be a transparent background in the picture.

You can move the picture to any location you want by changing the "B18" in the code.

You're welcome.