I have the following function:
I can call it in Excel and it works no problem. When I close the workbook, I get the following error: "member or data member not found" with ComboBox1A highlighted in blue.
Is there any reason why I would get this only when I close the document?
Thanks,
Lee
Code:
Private Sub UpdatePrice()
Sheet1.Range("E4").Value = Sheet2.Range("B1").Value + Sheet1.ComboBox1A.Value
End Sub
Is there any reason why I would get this only when I close the document?
Thanks,
Lee