ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to create labels in a UserForm dynamically and be able to resize them with the mouse. (https://www.excelbanter.com/excel-programming/317624-how-create-labels-userform-dynamically-able-resize-them-mouse.html)

Pierre Archambault

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




All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com