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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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