Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Resize Data Labels daywata Excel Discussion (Misc queries) 1 September 20th 06 10:18 AM
How can I create and display a chart dynamically on a UserForm wi. cc Charts and Charting in Excel 1 February 14th 05 02:44 PM
How to Resize Userform? hce[_26_] Excel Programming 0 October 24th 04 01:19 PM
How to Resize Userform? hce[_25_] Excel Programming 5 October 24th 04 12:12 PM
Referencing labels dynamically. liddlem[_3_] Excel Programming 2 January 16th 04 05:24 PM


All times are GMT +1. The time now is 06:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"