Creating and controlling objects in a UserForm

[Pierre Archambault]

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

 

[Stephen Knapp]

Pierre:

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