calendar to single click on date

chubbychub · #1 04-03-2019, 02:11 PM

I have a user form, that when I pic on the date I have to click "ok' button to select it, I got a code from a guru, but it wont do it for a just clicking on the date, I get error. this is for word 2013. here is the code (this is from Trevor Eyre's date picker)

Code:

Function BasicCalendar(StartDate As Date) As String
Dim oFrm As New frmDatePicker
    BasicCalendar = oFrm.GetDate(dateToPick:=CStr(StartDate), _
                                 OKButton:=False, _
                                 CancelButton:=False, _
                                 ShowTitleBar:=False)
lbl_Exit:
    Set oFrm = Nothing
    Exit Function
End Function

if someone caould help me please.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I create a table in Word where I can single click a cell and it automatically highlights?	QA Inspector	Word	2	05-14-2015 07:22 PM
Auto population of a single date	bremen22	PowerPoint	1	08-04-2014 11:59 AM
Exchange - Single public calendar?	critikull	Outlook	0	05-15-2012 08:18 AM
Use a single calendar in Outlook 2010	TimTDP	Outlook	0	04-03-2012 11:30 PM
Single-click to archive emails to dif't folders based on original folder?	Dougmeister	Outlook	0	09-23-2010 01:18 PM