If you are using more than one document for same interface or maybe there is relation between multiple files, then editing each of them individually would become much hectic. You can use this code to merge multiple files to work in integrity. Here is the code for it,
Code:
Public Fileway As String
Private Sub UserForm_Activate()
Fileway = ActiveWorkbook.Path
Me.Caption = Me.Caption & "Filepath:" & Fileway
End Sub
When using this insert names of the files that you want to use as database. Put the name with extension in place of Filepath: that I have marked with red color.
Bookmarks