Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating and controlling objects in a UserForm
Pier
My first idea would be to place a spin button to the side of the bar that is not to expand. The user would then click the left or right button to enlarge or contract the bar. You would watch the .length property to make sure that the bar doesn't extend beyond some predetermined limit (if you need to do that). Steve in Ohio "Pierre Archambault" wrote: Hi everybody, Here's my problem. I must represent time durations with colored bars (Image objects) in a UserForm. Because the program is meant to run at different custumers, the number of bars will vary. So I must generate those bars on the fly. I know it's possible but how can I access their MouseDown, MouseOver and MouseUp events, I can't write code for these events; they don't even exist in creation mode. I want to be able to resize those images using the mouse. Everything must be done in a UserForm because all the data isn't available to the user, the whole application is running through UserForms. Thank you for your help. Pierre |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating and Controlling a User data Entry Sheet | Excel Discussion (Misc queries) | |||
Apply vba code to multiple userform objects | Excel Programming | |||
Apply vba code to multiple userform objects | Excel Programming | |||
Creating remote objects | Excel Programming | |||
Can you Copy Objects from a Worksheet to a Userform | Excel Programming |