rjplante
Well-known Member
- Joined
- Oct 31, 2008
- Messages
- 569
- Office Version
- 365
- Platform
- Windows
I have a formula in cell BF5 that monitors two other cells and when they have data entered the cell is populated. I would like to have a save macro called. I have the code listed below and whenever I click back to the worksheet to enter the data, I get a message box that says "compile error: Sub or Function not defined." and then the line in red is highlighted yellow and the line in blue is selected.
I don't know how to get the macro to work.
I don't know how to get the macro to work.
Rich (BB code):
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("BF5").Value <> "" Then
Call Execute_save
End If
End Sub