Datepicker to show todays date

ipbr21054

Well-known Member
Joined
Nov 16, 2010
Messages
5,602
Office Version
  1. 2007
Platform
  1. Windows
I have a userform where i have a datepicker on it.
I open the form & currently i see the date as 31/07/2024 as opposed todays date.

Where do i mkae the change to show the date correctly

EaseUS_2024_08_ 2_14_40_13.jpg
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
I have this code in use but see the eror message when i open form.

VBA Code:
Private Sub UserForm_Initialize()
    Me.Datepicker1.Value = Date
        '-------------------------------
    Me.StartUpPosition = 0
    Me.Top = Application.Top + 100  ' MARGIN FROM TOP OF SCREEN
    Me.Left = Application.Left + Application.Width - Me.Width - 250 ' LEFT / RIGHT OF SCREEN
  
    '-------------------------------
    
    ' to populate vehical list combobox1
    With Me.ComboBox1
        .RowSource = ""
        .List = Sheets("INFO").ListObjects("Table2").DataBodyRange.Value
        .MatchRequired = False
    End With

End Sub

EaseUS_2024_08_ 2_14_52_24.jpg
 
Upvote 0
Datepicker name was different,now both the same it works
 
Upvote 0

Forum statistics

Threads
1,221,417
Messages
6,159,786
Members
451,589
Latest member
Harold14

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top