This is what I am trying now but it still doesn't work. When I declared the workbook within this private sub it worked great. I just want to make this a public function or whatever it takes so I can use the same text in all my macros without having to set it. This is what I have.
Public InvManageWB As Workbook
Public Sub workbookvariable()
Dim InvManageWB As Workbook
Set InvManageWB = Workbooks("Inventory Management DropBox.xlsm")
End Sub
Private Sub ProductSelection_Change()
InvManageWB.Sheets("Transaction").Label2.Caption = Format(InvManageWB.Sheets("Dummy").Range("LookupPrice").Value, "$###0.00")
End Sub
Bookmarks