mouse

I know how to use the MouseMove event, understand the logic behind the MouseDown/Up events. However, there seems to be a more advanced level, e.g. combining those 3 events to create a Drag&Drop opportunity for controls which don't initially have it (e.g. ListBox does). And I need to understand...

So I have been having this same problem for a long time. I just work around it, by scrolling with my mouse, which can be tedious. We used to have MS 2016, now we have Office 365. Problem existed on both. The document is a shared document, old school, not the internet sharing because I need to be...

I have a macro that extracts data from Microfocus RUMBA Mainframe Display and puts in Excel rows one after the other. I have created a Global Mainframe object and that is used for extraction to Excel. But when the process is running and if user decides to stop the processing he cannot click on...

For several years I have been using:- Function clickMouse() mouse_event MOUSEEVENTF_LEFTDOWN, 0, 0, 0, 0 mouse_event MOUSEEVENTF_LEFTUP, 0, 0, 0, 0 Sleep 50 End Function to click the mouse. However, after recent auto-upgrades, it has ceased to work. Anyone got any ideas why - and...

I have 3 charts in a worksheet. All of the charts share the same x axis. I would like to a trend cursor to each of the charts to clearing indicate the y value for each of the charts at the x-value the mouse pointer is located at. There are probably several parts to this question. but looking...

I have a large set of cells with Text inside I need to sort into lists and in such a way that each list produced from the first omits one cell. The difficulty for me in particular is that the number of cells can vary. To illustrate simply below is a simplified set of cells with one word in each...

Hello How is above statement in RED justified with below code as i am stuck and color does not change when the mouse is outside the border or edge of command button Private Sub CommandButton1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal x As Single, ByVal y As Single)...

Is there a keyboard shortcut to paste Values with Transpose?

I'm sure this has been asked before - if so please direct me. I have Fields: LastName,FirstName,Spouse,Position,Spouse Position It's a list that also includes people that are singles. Just looking for direction how to keep my original list AND elsewhere to have a list that derives and splits...

Since I'm not that well versed in VBA, unlike most on this forum, I was hoping someone could answer a quick question regarding "Sub ComboBox1_Click()". I thought this was a mouse click event, but as I seem to be finding out, it is also a key click event. Is this correct? I'm wondering...

Hello Everyone , I want to put a comment to a cell using VBA through command button. Once the comment is entered the cell is dimmed. The comment can be viewed by hovering the mouse on the cell, through a pop-up or button.

Assuming I have two codes, how can I wrap my code to detect if Enter key was pressed or a mouse click? So, if it is enter key it should run one code, if mouse click it should run another code

Am running Excel 2016 (64 bit) on 64 bit Windows 10 machine. When a called macro changes to view a worksheet with Panes set, most times the keyboard arrows will not change the view. Sometimes they move the cursor off the page, sometimes the cursor is non-responsive. Also, cannot mouse click...

I have two worksheets' data. Worksheet Tags. Worksheet Records. Only Worksheet Tags has data in col P. Worksheet Tags has only SOME of the same data in col A that Worksheet Records has in col A. With matching data in col A, whatever I can do to copy Worksheet Tags' data in col P, inserting...

Hello Excel experts... I thank you in advance! :-) I need to find words in column U, and if found, add comma-space-assigned number in column R (in same row). (without disturbing content already in column R. I've begun doing this manually.) Example of what I'm trying to do: (Would love to...

Hi all I am trying to find a value from column C in Columns AC:AE inclusive and if found return the row number of the initial value for example: If the value of C2 [DOG] is found in F7 then 2 is returned to A2 Column C will contain unique values Hope this makes sense - even if the example is...

Is it possible in VBA to detect a system wide key or mouse movement? I need to trigger an *action* when any key or mouse movement is detected system (Windows) wide

Windows 10 v 1903 MS Office Pro 2010 My (wireless) mouse wheel has recently stopped being able to scroll up/down in Access tables/queries. I use this feature a lot, due to the nature of the length of the tables/queries I use, so it's a huge frustration for me. I've tried a different mouse but...

I need a code for mouse wheel to scroll the scrollbar on a frame. Note: the userform itself is modeless.

Sheet1: <tbody> 1 Cat 2019-05-21 Error... This, this, and this 2 Dog 2019-05-21 Error. This, this, and this 3 Mouse 2019-05-25 In order - that, that, and that 4 Fish 2019-05-26 Where, when, why, and how </tbody> Sheet2: <tbody> 5 2019-05-22 Dog ... 6 2019-05-22 Fish ... 7...