Hi everybody.
The macro code below detects whether cell G5 is empty or not and if it's not empty it runs a macro (called "MyMacro")
However, when that cell gets populated via an item selected from a list-box the macro does not recognize right away that it's populated, only when i double-click on a random cell and then click out does the macro run.
Is there a way to make the macro as soon as an item is selected from the list box?
Private Sub Worksheet_Change(ByVal Target As Range)
Dim ws As Worksheet: Set ws = Sheets("Sheet1")
If Not ws.Range("G5") = "" Then Call MyMacro
End Sub
Bookmarks