ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating and controlling objects in a UserForm (https://www.excelbanter.com/excel-programming/317719-re-creating-controlling-objects-userform.html)

Stephen Knapp

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





All times are GMT +1. The time now is 01:44 PM.

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