VBA date formatting

[PGD15]

Hi People.

I want to enter a value into a combo box on a webpage. I can access the combo box no problem and enter a value. ... my issue is the value is a date and needs to be entered in a certain format which is dd-mm-yy. However as this range changes on a daily basis i cannot put

.document.getelementbyname("datefrom")(0).value = 01-01-01 (as this changes)
i need to do something like
.document.getelementbyname("datefrom")(0).value = worksheets("sheet1").range("a1") (to allow for the change)

however this picks up the time and other infomation regarding todays date when i only want it in my format.

Is anyone able to help me correct my date format into that of dd-mm-yy so i can enter this into my combo box

 

[sykes]

Wouldn't this work?:

.document.getelementbyname("datefrom")(0).value = format(worksheets("sheet1").range("a1"), "dd-mm-yy")

 

[PGD15]

i solved it now, don't worry was being a pleb!