unload userform if greater than certain row

[wilg]

I have a userform that will activate if in column a. However I do not want it to activate if it is below a certain row.

eg range("ak301").value which gives me the row number I want the userform to stop activating at.

Is there a way to use an if statement to include if below row ak301's value (eg row 354) then unload userform or exit?


my userform is called Names1


[vba]Private Sub UserForm_Initialize()
ComboBox1.RowSource = "COMPLETE_NAME"
ComboBox1.Value = ActiveCell.Value
With ComboBox1
.SelStart = 0

.SelLength = Len(ComboBox1)

End With
End Sub[/vba]

[wilg]

I use the selection change to initialize userform below. Would this be where I put code?

[VBA]Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Column = 1 Then
Names1.Show

End If
End Sub[/VBA]

[shrivallabha]

I use the selection change to initialize userform below. Would this be where I put code?

[vba]Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Column = 1 Then
Names1.Show

End If
End Sub[/vba]

Something like:
[VBA]Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 1 And Target.Row < Range("AK301").Value Then
Names1.Show
End If
End Sub[/VBA]