Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cycle through images on UserForm
I want to create a form that displays when I run a macro. On this form I
would like to display 6 images in turn to represent the progress of the macro and cycle through them (the images being differing numbers of black blocks, like a loading bar). I have put the images on the form, but I don't know how to hide all but the first one, then cycle through the rest and showing each for 2 seconds, then going back to the start. Any help?? |
#2
|
|||
|
|||
You may want to look at the way John Walkenbach showed a progress bar:
http://j-walk.com/ss/excel/tips/tip34.htm It sounds like it'd be the same. cdb wrote: I want to create a form that displays when I run a macro. On this form I would like to display 6 images in turn to represent the progress of the macro and cycle through them (the images being differing numbers of black blocks, like a loading bar). I have put the images on the form, but I don't know how to hide all but the first one, then cycle through the rest and showing each for 2 seconds, then going back to the start. Any help?? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform textbox | Excel Worksheet Functions | |||
Gray box appeared around images | Excel Discussion (Misc queries) | |||
Userform | Excel Worksheet Functions | |||
Problems pasting images into Excel | Excel Discussion (Misc queries) | |||
Using excel to select only matching images... | Excel Discussion (Misc queries) |