Hi All,

How can i disable the commandbutton in userform once it has been opened? It will only activated once i clicked the search button and if the search returned results.
I used below code but its getting an error.


Private Sub UserForm_Activate()

ProceedButton.Visible = False

End Sub