mouse

  1. R

    Click the mouse with VBA not working

    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...
  2. I

    Trend cursor on Excel Chart

    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...
  3. H

    Text cell list sorting problem

    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...
  4. S

    MouseMove Event : When mouse is outside the edge or border of command button would like to change the background colour of commandbutton

    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)...
  5. M

    What is the quickest way to Paste Values by Transpose without using the mouse?

    Is there a keyboard shortcut to paste Values with Transpose?
  6. L

    List of Names: Extract Address like info into individual row list (eg. Husbands/Wives/Singles)

    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...
  7. TAPS_MikeDion

    Quick stupid question about "Sub ComboBox1_Click()"

    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...
  8. A

    Comment box with VBA, which pops- up on mouse hower

    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.
  9. Y

    Detect Mouse Click and Keyboard key

    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
  10. D

    Arrow keys and mouse not working consistently with scroll and panes

    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...
  11. J

    Find matching data in 2 wkshts, copying/pasting data from same-row col P to the others col P

    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...
  12. J

    Find text in one column = add "#, " to different column?

    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...
  13. M

    return the row number when a match is found

    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...
  14. 6

    do an *action* when any key or mouse movement is detected

    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
  15. P

    Mouse wheel no longer scrolling up/down in Access 2010

    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...
  16. Y

    Mouse Scroll wheel for frame scroll bar

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

    VBA: When conditions are met, a message box will pop up

    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...
  18. D

    Mouse wheel scroll through ComboBox dropdown.

    Hi, I'm using Excel 2016 64-bit and have a ComboBox with a dropdown that contains 150+ lines. I'm trying to set it up so that I can scroll through the lines with the mouse wheel.
  19. W

    F2 moving cells with mouse

    I'm at a bit of a loss here. On every version of excel I've ever used (currently 2016) when you disable "Allow Editing Directly within Cell" you can then press F2 where the cells used in the formula will be highlighted by various colors and with the left mouse button you could move the...
  20. W

    How to freeze panes on mouse scroll

    Hi, I am trying to hide some rows and then freeze panes on mouse scroll. 1. User scrolls down 2. Hide rows 1-5 3. Freeze new rows 1-5 Is this possible? Sub FreezeRow() ActiveWindow.FreezePanes = False Rows("1:5").Select ActiveWindow.FreezePanes = True End Sub

Some videos you may like

This Week's Hot Topics

Top