cursor

  1. A

    Can't drag down/right to automatically populate cells? Excel for Mac 15.32

    Hi all, Suddenly today, the little cursor to drag down to fill has "stopped working". I have a VBA-defined Name which is called by "FontColor" in my function as in the picture (I had to block out sensitive info). The code for FontColor in my defined name is: GET.CELL(24,Sheet1!X3:X252). The...
  2. S

    Trying to get Excel to automatically navigate to next row and add timestamp after scanning

    So I'm trying to do 2 things, I'm scanning serial numbers into Excel and taking inventory. Cell A1 would be the serial number B1 is the date and C1 the time that would automatically populate on every scan. After Scan is done have the cursor automatically move to the next row (A2) waiting for the...
  3. A

    Macro that will move cursor after every 10 sec

    Hi I need macro that will move cursor position on excel after every 10 sec and dosen't let system to go on idle mode. Please help with the same.
  4. D

    Formula / VBA Code to Display in A1 (sheet 1) Current Cursor value of sheet 2 (Column A)

    I would like a formula (or VBA Code) in Cell "A1" of sheet 1 that would give me the cursor value (column A) of sheet 2 . In other words: If the cursor were in Cell "C10" of sheet 2, then Cell "A1" of sheet 1 give me value of cell A10 of sheet 2 Any ideas. Many Thanks
  5. S

    Cursor changed from arrow to cross

    This is crazy. My colleague opened a file and now her cursor is no longer an arrow but shows as a cross similar to the cursor one gets when deleting a text box. A real stumper. I can't find an option to change the cursor. Any ideas? thanks Steve
  6. S

    Choosing Slicer Selection causing cursor to jump to connecting pivot table

    I have spent the last hour looking at different forums looking for a solution to my issue. I have a... "Product Family Slicer" with 5 VALUE STREAMS to choose from in the slicer. However, each time you select a specific Product Family, the cursor jumps halfway across the spreadsheet and lands...
  7. S

    Choosing Slicer Selection causing cursor to jump to connecting pivot table

    I have spent the last hour looking at different forums looking for a solution to my issue. I have a... "Product Family Slicer" with 5 products to choose from in the slicer. However, each time you select a specific Product Family, the cursor jumps halfway across the spreadsheet and lands on...
  8. B

    How to get cursor to go to next text box automatically

    Hi, I have five textboxes placed vertically. I have managed to make the cursor start in the first textbox. I will be entering one or two digits into each textbox. Is there any way that after I enter the digits, that I can hit the enter key to make the cursor jump down into the next textbox so...
  9. G

    Prevent double click jump to source

    I am using a double click to run some code. If the user double clicks an inappropriate cell, he get a message that the cursor is "out of range". If he clicks on a cell which is reading a value from another location, the code provides the message, but then selects the source cell for the...
  10. W

    How to get cursor location to open on a specific cell adjacent to todays date

    Hi Guys, I have a question, i have a time card with dates in column C, with the dates of the month filled in each row (example: C1=1/1/18, C2=1/2/18, C3=1/3/18, etc... Can i have a workbook_open code so that it searches that column or range (C1-C50) for todays date and then puts the cursor...
  11. G

    I need the cursor to go to the last non-zero in column C

    Hello, I've got a macro for printing labels. I need the cursor to go to the last non-zero in column C after capturing the information and printing the label. I wrote this macro with the macro recorder. So, I know that I'll have to hard-code this last function. I don't know how to do this in VBA...
  12. R

    place cursor in cell next to cell that macro just entered the date into after matching a value

    I am trying to write VBA code to match a value/barcode, enter a date/timestamp then move the cursor to the cell to the right of the timestamp. I have the match and time stamp working but cannot figure out how to have the cursor move to the cell to the right of the time stamp (so in a long list...
  13. S

    textbox the cursor jumps to the end of the sentence

    Hi All, The TextBox on User form gets a value from worksheet cell. When I want to edit a text, the cursor jumps to the end of the sentence. any idea ? (Excel 2007) Thank you in advance.
  14. B

    How can I have a pop up image in a cell, on a Mac

    Hi Guys, I have seen this before, and i'm hoping that it's available on Excel 2016 for Mac, v15.40 The idea is to have an image in a cell, and when the cursor is over the cell, the full image appears, then disappear when you move the cursor. it's very similar to how Comments work within a...
  15. Y

    A stucked cursor at option "allow users edit ranges"

    Hello, At Office 365 A5 in Excel 2016 macro file which is edited at Co-Authoring I have an error of stucked mouse cursor. The stucked mouse cursor apears when I try to click at a cell, that was edited by the option "allow users edit ranges". A screenshot of the stucked cursor is attahced. The...
  16. Jaafar Tribak

    Event triggered when a shape is moved (ShapeMove Pseudo-Event)

    Hi all, This is a little vba class that you can add to your project in order to catch mouse drag and dop operations performed on shapes embedeed on worksheets. The code doesn't use a timer nor does it use a loop so it is safe and should have much less impact on performance. If you set the...
  17. H

    Erase row if column contains certain value

    Hello, I got this very simple macro that allows user to erase a complete row. It is manually activated by placing cursor in a certain row/cell and executed by CTRL+SHFT+E. Sub Erase_item() ActiveCell.EntireRow.Select Selection.Delete Shift:=xlUp Range("A6").Select End Sub After...
  18. B

    Controlling Cursor position with Macro

    Hi guys I'm hoping somebody can help me with this Macro code. I want a macro that moves the cursor to the 1st empty row on column D or 1st empty row on column AP (the lowest row number should decide which column the cursor gets placed) So if column D's 1st free row is lower than column AP than...
  19. S

    move down cursor copy the row in other sheet

    <tbody> I want to move the cursor to down cell in column c in other open workbook "OM tracker" "Sheet1" & copy selected value from the row each time. exa. cursor is moved down on a click to cell C4, now copy value from cell D4, G4, H4 & paste in other workbook "Project orphan". <tbody>...
  20. R

    Select Cells based on other Cells Value

    Hello Everyone, I am working on database and need your help in one macro. I have one drop down linked with V1 and have one search box. V1 will be the country name. So i want If V1 is australia then C8:P9 should be selected and cursor automatically reach on C3. Same if V1 is Austria then...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top