Listbox Opening

[will2learn]

I have a listbox on a userform which contains various percentage numbers. When one of these is selected cell N3 is populated.

Is it possible so that when the userform opens, the percentage number that appears in cell N3 is selected in the listbox of the userform? If so how?

 

[MickG]

Try this:-

Private Sub UserForm_Initialize()
Dim n As Integer
For n = 0 To ListBox1.ListCount - 1
    If ListBox1.List(n) = Range("N2") Then
        ListBox1.ListIndex = n
    Exit For
End If
Next n
End Sub

Mick