Hello out there,
I have been trying to insert date field in office 365 excel VBA user form.
kindly help me resolve this issue.
Hello out there,
I have been trying to insert date field in office 365 excel VBA user form.
kindly help me resolve this issue.
Download this file for an example.
Bernie Deitrick
Excel MVP 2000-2010
Thanks but, I want to use it in VBA user form.
That file has example code for a VBA userform option.
Try the attached approach - the user-form is launched by the 'Push Me' button - on the form there are a couple of date fields - click into these and a calendar will appear, choosing a date places the date in the textbox.
The full code for the calendar is included and choice is controlled in the Class Module.
I have attached the code also in a PDF where the code flow is better illustrated and incorporation of other features of the user-form may be of assistance.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
Hello thanks you all for replying to my thread. After day of researching, I was able to create a date pick calendar using VBA form. But, the issue now is how to link that calendar to my main application form to enable user to pick a date from the calendar. I need your help please.
There are several ways to do this - the tedious long way of naming all your buttons OR the more simple way as per my post #5.
If you upload your your creation I will show you how - far easier to demonstrate than writing an essay on how and why.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks