vba courses london - Flickering screen

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Flickering screen

Nataliya has attended:
Excel VBA course

by - delegate Nataliya [1 post] (2007 Feb 22 Thu, 09:52) Reply

how do I stop screen flickering?

Excel VBA courses and other windows problems

by - trainer David gold contributer [428 posts] (2007 Feb 22 Thu, 13:01) Edited on 2007 Feb 22 Thu, 13:01 Reply

Hi Nataliya

Hope you found your Excel VBA course a great help.

It sounds like the refresh rate on you monitor has been changed. To alter this right click the windows desktop, then go to the settings tab and then advanced and then select the tab that says monitor and you should find the refresh rate settings.

Hope this helps

David

· Company Roles in Visual Basic Training
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?

Vba tip:

Use VbNullString instead of

When needing to default a String variable back to it's default of "" use vbNullString as in the following example:

Sub ClearText()

Dim strEmpName As String

strEmpName = "John Smith"
MsgBox strEmpName

strEmpName = vbNullString
MsgBox strEmpName

End Sub

View all VBA hints and tips