1. V

    Vba Application.Onkey Press F3 not working during Cursor flashing inside Cell

    I create some code for test Press F3 on VBA Excel, the function is Application.OnKey this method excel not working during write on the Cell and Cursor Flashing inside Cell, but work fine after pressing Enter Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.OnKey...
  2. P

    VBA to move the “flashing line cursor”

    Hi All, Is there a way through VBA to move the “flashing line cursor” of which blinks inside a cell? For example, if the flashing line cursor remains idle inside a cell for example over a minute? This case is popping up when the user starts to type an entry inside a cell then leaves the...
  3. L

    .autofilter to certain column

    G'day guys. Have the below code: Set TB = ActiveWorkbookWorkbooks.Open "C:\Users\Luke\Desktop\LIVE\Best Shed Scheduler Flashing.xlsm" Set OB = ActiveWorkbook erow = OB.Sheets("Corner Flashing Machine Data").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Row TB.Activate...
  4. B

    Flashing cell in microsoft excel 2010

    I am trying to write a code for flashing cell in Microsoft excel 2010. I am using a code found online to do this however I continually get an error, the bold line Runtime error '1004' Method 'OnTime' of object'_Application' failed Dim NextTime As Date Sub StartFlash() NextTime = Now +...
  5. R

    Why is the screen flashing when I insert a picture?

    I have a project that inserts pictures in a worksheet, as triggered by a worksheet_change event. The problem is, whenever I trigger the event, and the pictures are inserted automatically, there is a brief flash that is very unappealing. I have tried everything I can think of isolate the...
  6. B

    Blinking Text on Userform

    I have a user form that has a text box that displays either OK or BAD based on a cell value on a sheet named "FORM-DATA. I have put code in to change the color of the font based on the value, but I woudl like to make the text flash if it says "BAD". I have searched all the threads i can...
  7. VAndre

    slow refresh times in excel 2007 for workbooks with user-defined functions

    I have a couple of workbooks that use VBA functions. They have worked well in Excel2003 environments, but refresh time is very slow once I migrated to Excel2007. The speed is so slow that there is a visible series of blinks every time I refresh. It's really bad (I literally got a migraine the...
  8. Jaafar Tribak

    Cool Pulsating Cell !!

    Hi all. I just thought I would share this with you. PulsatingCell.xls"]PULSATING CELL DEMO. Takes a snapshot of the Cell and uses a Timer to expand and shrink it periodically. The resulting visual effect is that of a pulsating cell which could ,for example, be used to draw the user's...
  9. J

    Conditional Formatting progress tracker.

    Hi I have to produce an excel spreadsheet with conditional formatting: The spreadsheet is a progress monitor on various stages of projects. Each project has a target completion date and three stages. Stage 1 is meant to be completed 30 days before the target completion, stage 2 is meant to be 20...
  10. I

    Flashing Date in excel

    Hello All, this is my very first post and also first question since I am breaking my brains over this one since I have been working with Excel 2007. I have solved many problems with the solutions presented here. I have multiple workbooks which contains numerous different dates. and I need to...

Some videos you may like

This Week's Hot Topics