Date and Time Picker on UserForm

randolphoralph · Dec 24, 2008

I am trying to use the Date and Time Picker 6.0 and I have add it to the userform and named it DateofContact.

When I play the userform I get a error stating:

"Compile Error-Method or Data member not found"

Below I have added the code and it shows in red where the problem is.

Code:

Private Sub UserForm_Activate()
     
    PSA.Text = Cells(lCurrentRow, 2).Value
    cboTypeofContact.Text = Cells(lCurrentRow, 3).Value
    DateofContact.[COLOR=red]Text[/COLOR] = Cells(lCurrentRow, 4).Value
    TimeofContact.Text = Cells(lCurrentRow, 5).Value
End Sub

I am not sure what to put in its place.

randolphoralph · Dec 26, 2008

Does anyone know how to add Date and Time Picker on the fly in VBA code? I found out that not all the users have the Date and Time Picker.

theozz · Dec 26, 2008

Try;

Code:

Me.DTPicker1.Value = DateSerial(2008, 2, 2)

abd refer this...

Code:

MsgBox TypeName(Me.DTPicker1.Value)

randolphoralph · Dec 29, 2008

I found out that the majority of the users do not have the date and time picker. Due to security the users are unable to install add-ins or any additional controls to the vb toolbox.

In order to work around this I need to add the date/time picker into the project code.

Does anyone know of a open source date/time picker? I have looked around and everyone that I find has the source code protected.

RoryA · Dec 29, 2008

If your users don't have the Date/time picker and can't install it, then you can't use it, whether at design time or at runtime.
Why not just have controls for day, month and year and validate the date as it is entered - it's a lot easier.

randolphoralph · Dec 29, 2008

Rory,

I am not looking to use the Date/time picker but I am looking for something similar that can be written directly into the VBA project and would not require a install.

What did you mean by having controls for day, month and year and validate the date as it is entered?

-Randolph

RoryA · Dec 29, 2008

I meant simply adding say a textbox (or combo) for the day, a combo for the month and a textbox for the year. You can then concatenate and validate the date on completion of the three controls.

randolphoralph · Dec 29, 2008

Oh ok...Gotcha! Thanks

JohnCM · Feb 26, 2009

I am curious though on the subject of activating the date picker on machines that use the macro. As vba writers we know to right click the toolbox and check the appropriate box put that is far beyond the level of those who will be using this macro when distributed. Any ideas of how to turn on that functionality before the Userform opens?

RoryA · Feb 26, 2009

If they have the control, your code will work. If they don't, it won't and they cannot simply add it.

Date and Time Picker on UserForm

randolphoralph

Board Regular

Excel Facts

randolphoralph

Board Regular

theozz

Active Member

randolphoralph

Board Regular

RoryA

MrExcel MVP, Moderator

randolphoralph

Board Regular

RoryA

MrExcel MVP, Moderator

randolphoralph

Board Regular

JohnCM

New Member

RoryA

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

Date and Time Picker on UserForm

Board Regular

Excel Facts

Board Regular

Active Member

Board Regular

MrExcel MVP, Moderator

Board Regular

MrExcel MVP, Moderator

Board Regular

New Member

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock