I would like to run a specific macro to highlight a row when i change the date from a DatePicker ActiveX control.
That is, I have a macro that works if i change a date in a cell myself. I have now added the DatePicker to select dates from a calendar which i have linked to that same cell.
When i change the date in the DatePicker, the macro fails to run.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("SearchDay")) Is Nothing Then
FindSelectedDate
End If
Private Sub DatePicker_CallbackKeyDown(ByVal KeyCode As Integer, ByVal Shift As Integer, ByVal CallbackField As String, CallbackDate As Date)
Private Sub ActiveXCalendarName_Click()
Me.DateFieldName = ActiveXDatePicker.Value
Call DateFieldName_AfterUpdate
End Sub
Range("SearchDay") refers to the cell containing the date which is successfully populated by the DatePicker ActiveX control
FindSelectedDate is the macro i want to run
DatePicker is the name of the DatePicker ActiveX control
Any suggestions?
Bookmarks