View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pierre Archambault Pierre Archambault is offline
external usenet poster
 
Posts: 35
Default How to create labels in a UserForm dynamically and be able to resize them with the mouse.

Hi everybody,

Here's my problem.

I must represent time durations with colored bars (Label objects) in a
UserForm. Because the program is meant to run at different custumers, the
number of bars is based on user input : it will vary. So I must generate
those bars on the fly. I think thit is 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 the users to be
able to resize those bars 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