I have a userform that pops up when a button on a worksheet is pressed. I would like the userform textboxes to be blank when it pops up. (I am unloading the userform each time it closes.) I assume that "UserForm_Initialize" should be blank for the userform textboxes to be blank. I also have a search textbox on the userform that searches the worksheet for a certain number and then populates the userform with info on the found number's row. Would this code have to be put into the search textbox code then? I am use to putting code into the "UserForm_Initialize" something like:
With this code, I could call the UserForm_Initialize from the search textbox to populate the userform, but again, I want the userform to be blank when I first call it. Any suggestions?
Code:
Private Sub UserForm_Initialize()
'Initial values of IRF Window
tbDC = Cells(ActiveCell.Row, 1).Value
tbJobNo = Cells(ActiveCell.Row, 2).Value
With this code, I could call the UserForm_Initialize from the search textbox to populate the userform, but again, I want the userform to be blank when I first call it. Any suggestions?