Excel vba application screenupdating not working

Posted by / 11-Aug-2020 16:42

Value = 60 Set rng = Range("A1") On Error Go To notfound Row = Cells.

Value "" Then 'the Is Numberic function has screenupdating set to false at beginning and true at end If Is Numeric(Right(rng.

So from my viewpoint Screen Updating is not working correctly.

I tried adding Doevents after the screenupdating statements and that has not worked either. Value = Partnernum End If Set rng = Range("A1") Set rng = Cells(Row, col5) If rng. Text Box3 = Address2 Set rng = Cells(Row, col6 1) 'the Is Numberic function has screenupdating set to false at beginning and true at end If Is Numeric(Right(rng. Find(What:="BP Postal Code-5 Dig", After:=rng, Look In:=xl Values, Look At:= _ xl Part, Search Order:=xl By Rows, Search Direction:=xl Next, Match Case:= _ False, Search Format:=False). Screen Updating = False With Active Sheet lastrow1 = . Row End With 'Set rng1 = Range(Cells(2, col2), Cells(lastrow1, col2)). Find(What:=tagfind, After:=rng, Look In:=xl Values, Look At:= _ xl Whole, Search Order:=xl By Rows, Search Direction:=xl Next, Match Case:= _ False, Search Format:=False).

excel vba application screenupdating not working-10excel vba application screenupdating not working-76excel vba application screenupdating not working-44

When the user selects the sheet (Using a Radio Button) a procedure is run that selects the sheet and activates it. Screen Updating = False, then some code runs which sets up the sheet and activates it. Now after some investigating I realized that Excel was not done activating the sheet so if I wait long enough the sheet might display.

One thought on “excel vba application screenupdating not working”