Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Position of a UserForm

Many thanks Shawn,

I found your post useful because it was the only reference I could find on
how to convert points to pixels.

Having found this, and consequently solved my problem, someone in this group
may be able to tell me why the problem exists in the first place...

I have a user form with 5 CheckBoxes arranged in a column. The top CheckBox
is an 'All' option called cbAll. The idea is that when a user clicks on cbAll
all the other CheckBoxes are set to the same value as cbAll. The other
CheckBoxes have 'Click' events that when set to False will also set cbAll to
False and when set to True will check the status of the CheckBoxes and set
cbAll to True if they all happen to be True.

Nice and straightforward methinks until I discover that the '_Click' event
behaves like a '_Change' event. Even though the CheckBoxes were not clicked
by the user the '_Click' events were running when the values were changed by
the cbAll code.

I now have a perfectly working 'work-around' but feel a bit miffed at having
to spend two days getting there.

I'll be happy to post my solution if anyone is interested.

Kind regards,
Nick.
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
UserForm position Steve Excel Discussion (Misc queries) 1 August 26th 07 04:50 AM
Userform Position Pete Excel Programming 4 February 20th 05 12:01 AM
Fixing UserForm Position Marston Excel Programming 1 August 26th 04 04:56 PM
Lock userform position Newbie Excel Programming 3 July 21st 04 02:41 PM
UserForm position Tim Excel Programming 2 February 12th 04 03:20 PM


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

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

About Us

"It's about Microsoft Excel"