mercredi 9 avril 2014

todays date and future date dropdown list in a ComboBox


Vote count:

0




every time i start up the file and click the macro for the userform, the combobox should have the list of dates from today and future dates, it can not have past dates.


this is the code that I have, it only inputs the date in the combobox and formats the value of the list. but i don't know how to list down the future dates in it.



Public Sub UserForm_initialize()
ComboBox3.Value = Format(Date, "dd/mm/yyyy")
ComboBox3.Value = Format(ComboBox3.Value, "dd/mm/yyyy")
End Sub


asked 43 secs ago






Aucun commentaire:

Enregistrer un commentaire