| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Spreadsheet screen flickers for a few second when using a condition
Hi
When I use the following script in Microsoft Excel to automatically update a figure based on a yes/no condition in cell c20 the screen flickers. The value and program does work but it is very pleasant to watch. Can anyone help? Wayne Private Sub Worksheet_Calculate() Sheets("Work Order Request").Select If Range("c20").Value = "yes" Then Range("g20").Value = "=c18" Else Range("g20").Value = "Enter CBA Number" End If ' Range("g20").Value = "=c18" End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Screen flickers and text disappears/moves?? | Excel Discussion (Misc queries) | |||
| Display Problem in Excel 2007: Screen flickers an rows blanked out | Excel Discussion (Misc queries) | |||
| spreadsheet too large on the screen | Excel Discussion (Misc queries) | |||
| my spreadsheet is too far up on the excel screen and I cannot cli. | Excel Worksheet Functions | |||
| Spreadsheet off screen | Excel Discussion (Misc queries) | |||
Threaded Mode
