Delay before the right drop down menu appears i when unhiding a row

[Godot60]

Hi,

I have a series of questions in rows where there are corresponding drop down menus for each question.

The questions appear one by one depending on the answer to the prior question. When a new question appears there is a delay before the corresponding drop down menu appears. The viewer sees the drop down from the previous question instead. Eventually the right drop down appears. Any way of preventing this delay? Thanks in advance.

 

[mole999]

what code do you use to drive the changes

 

[Godot60]

Here is a sample:

Private Sub Worksheet_Change(ByVal Target As Range)


If Range("C4").Value = "" Then
Rows("5:26").EntireRow.Hidden = True
End If
If Range("C4").Value = "Yes" Then
Rows("5").EntireRow.Hidden = False
End If
If Range("C5").Value = "No" Then
Rows("7").EntireRow.Hidden = False
End If

End Sub

 

[mole999]

so you could wrap with

application.screenupdating = false

application.screenupdating = true

which will remove some flicker