November 19, 2008 01:19am pst

1. danaseaman 98,121
2. jpaulino 74,107
3. Idle_Mind 45,870
4. rorya 44,850
5. GrahamSkan 41,220
6. PaulHews 33,439
7. angelIII 31,972
8. RobSamp... 30,084
9. webtubbs 23,525
10. shasunder 19,300
11. emoreau 19,200
12. mlmcc 18,646
13. zorvek 17,680
14. ee_rlee 17,650
15. EDDYKT 17,350
16. LSMCons... 17,300
17. robinu 16,475
18. FER_G 15,925
19. robberbaron 14,000
20. capricorn1 13,900
21. c0ldfyr3 13,575
22. Dhaest 12,419
23. shijusn 10,100
24. jeverist 10,000
24. VBRocks 10,000

1. Idle_Mind 523,605
2. danaseaman 260,045
3. GrahamSkan 219,005
4. emoreau 213,388
5. vinnyd79 208,855
6. angelIII 170,197
7. vb_elmar 167,017
8. Dabas 166,771
9. shijusn 147,034
10. Dhaest 142,115
11. EDDYKT 133,003
12. jpaulino 124,854
13. TimCottee 117,614
14. Sethi 107,849
15. edwardiii 101,199
16. JR2003 98,026
17. bruintje 95,512
18. ryancys 90,368
19. Computron 89,772
20. rorya 89,125
21. dbrckovi 88,665
22. zzzzzooc 83,209
23. fds_fatboy 76,385
24. PaulHews 75,811
25. appari 71,576

08.30.2008 at 05:05PM PDT, ID: 23691588

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.9

Trapping mouse click anywhere on UserForm

Asked by gbergsma in VB Controls, Microsoft Excel Spreadsheet Software

Tags: Microsoft, Excel, 2007, VBA

Hi,

I have a VBA application that modifies the content of captions and controltip text in another workbook. As the changes are made, the user is able to view the target UserForm after they have made changes to it.

I need to be able to prevent the user from clicking on the controls in the target Userforms, as executing the code behind those controls is not applicable to the process of modifying the content.

I need to be able to execute some specific code the first time a user clicks anywhere on the form - before they can interact with the controls. That code is likely just to close the form.

So I need to know how to trap the mouse click and use it to close the form.

Any ideas?

Cheers

Start Free Trial

Keywords: Trapping mouse click anywhere on Us…

	Title
1	Userforms
2	Userform modeless - modal
3	Excel - UserForms
4	Excel VBA userform control to view se…
5	Getting a Device I/O error when openi…
6	Excel - UserForms

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Trapping mouse click anywhere on UserForm

Asked by gbergsma in VB Controls, Microsoft Excel Spreadsheet Software

Tags: Microsoft, Excel, 2007, VBA

About this solution