Quote:
Originally Posted by gmayor
Basically yes. You can copy the FillBM function to the template module that contains the macro that calls the userform. That macro at its simplest would be something like
Code:
Sub AutoNew()
Dim oFrm As New UserForm1 'The name of the userform
oFrm.Show
Unload oFrm
End Sub
|
Hello again, graham! I've tried using the code but it gave me the error "Compile Error: Sub or Function not defined." And then the "Private Sub CommandButton1_Click()" is highlighted in yellow with the arrow outside the box and the 'FillBM' is also highlighted. When I went back to the document, I've also noticed that the bookmarks were once again gone. I wonder if I did something wrong.