If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Animating a worksheet with VBA

Thread starter Worf
Start date Jan 27, 2020

Overview Discussion

Worf

Well-known Member

Jan 27, 2020

Worf submitted a new Excel article:

Animating a worksheet with VBA - This post shows how to add movement to a workbook with code.

This is a demo version of a larger project. It shows how to animate a worksheet that does not quite look like one.

Here are the actions that can be performed:

Filling a tank

Recirculating a tank

Transferring water from one tank to another

To operate the pumps and valves, just click the corresponding buttons. Before switching a pump on, put it on manual mode at the bottom of the page,

The workbook link is below, it contains three sheets: main, alarm log...