Allen Browne Calendar

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

Bob Vance

My code for your calendar is getting an error "A syntax error"

Private Sub cmdcalendar_Click()
=CalendarFor([tbDayNo], "Select the sale date")

End Sub
 
The idea was to set the On Click property (in the Properties sheet) to:
=CalendarFor([tbDayNo], "Select the sale date")

If you want to use code in the event procedure, try:
Call CalendarFor([tbDayNo], "Select the sale date")
 
abcdefghijklmnopqrstuvwxyz
Allen Browne said:
The idea was to set the On Click property (in the Properties sheet) to:
=CalendarFor([tbDayNo], "Select the sale date")

If you want to use code in the event procedure, try:
Call CalendarFor([tbDayNo], "Select the sale date")

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Bob Vance said:
My code for your calendar is getting an error "A syntax error"

Private Sub cmdcalendar_Click()
=CalendarFor([tbDayNo], "Select the sale date")

End Sub
Click to expand...
Click to expand...
 
Back
Top