Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
UserForm position | Excel Discussion (Misc queries) | |||
Userform Position | Excel Programming | |||
Fixing UserForm Position | Excel Programming | |||
Lock userform position | Excel Programming | |||
UserForm position | Excel Programming |