View Single Post
 
Old 05-05-2015, 04:32 PM
rogelinepaula rogelinepaula is offline Windows 8 Office 2013
Novice
 
Join Date: May 2015
Posts: 22
rogelinepaula is on a distinguished road
Default

Quote:
Originally Posted by gmayor View Post
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.
Reply With Quote