[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Possible to get MouseUp event on a worksheet?

Posted on 2012-08-28
Medium Priority
Last Modified: 2012-09-04
Hello - is there a way to do this on a worksheet (not a chart) in Excel 2010 ?

I have worked with Windows API calls in Access app's before, so if that's how it's done, then I would just like to know... that that's how it's done... and maybe see an example... or a code snip...

Question by:mlagrange
  • 2
LVL 50

Assisted Solution

by:Martin Liss
Martin Liss earned 1000 total points
ID: 38342823
The events available on a worksheet are limited and MouseUp is not one of them.

You could however put an ActiveX textbox or other control on the sheet or on a userform. Note that some advise against ActiveX controls on sheets, but if you choose that method you can add code to avoid any problems that might occur.
LVL 85

Accepted Solution

Rory Archibald earned 1000 total points
ID: 38344422
FWIW, you can use APIs to subclass the excel window and intercept mouse messages but it's generally not that stable and I wouldn't recommend it.

Author Closing Comment

ID: 38363176
Thanks to both of you. I am beginning to wish I had done this with UserForm's, and I particularly needed to hear about possible stability problems.
Thanks again
LVL 50

Expert Comment

by:Martin Liss
ID: 38363775
You're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2012

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question