Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default 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



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
Creating and Controlling a User data Entry Sheet Crispy Excel Discussion (Misc queries) 0 June 2nd 06 11:11 AM
Apply vba code to multiple userform objects sjoopie[_2_] Excel Programming 2 November 5th 04 01:42 PM
Apply vba code to multiple userform objects sjoopie Excel Programming 2 November 5th 04 12:15 PM
Creating remote objects Erich Neuwirth Excel Programming 13 May 13th 04 11:53 PM
Can you Copy Objects from a Worksheet to a Userform Dave Baranas Excel Programming 0 August 14th 03 07:48 PM


All times are GMT +1. The time now is 06:21 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"