Userform will not return desired date format into textboxes

[kleigh99]

Hi Experts

I have been through so many potential breakthroughs in the past week via the net/forums/handbooks etc but cannot for the life of me find the exact code needed to return "dd/mm"yyyy" to my textboxes when i intend on updating exsiting data within my form.

Basically I have a textbox on the userform where i type a record in and it returns all matches to a listbox where i will then select my desired record to update upon selection it will populate all necessary textboxes/Combo boxes etc, 3 of which are date dependant, i have a command button to update and return the data to the spreadsheet as well as 2 other command buttons which close and add new row data. At the minute my spreadsheet displays the above mentioned format which is what i would like to have displayed when i need to update data or simply return values to the text boxes for client referencing purposes. I have tried heaps of codes none of which seem to return the same format as that of the spreadsheet. I currently dont have a code the give as an example as i have nearly given up.

I hope i have explained enough for anyone to grasp whats needed. If more information is required i will be happy to go into more detail

TIA

Kleigh

 

[AlphaFrog]

Use the VBA Format function to display a serial date as text.

TextBox1.Text = Format(Range("A1").Value, "dd/mm/yyyy")

 

[kleigh99]

Would i be pasting the code within the textboxes afterupdate sub or in the userform initialize sub?

Thank you

Kleigh

 

[AlphaFrog]

Would i be pasting the code within the textboxes afterupdate sub or in the userform initialize sub?

Thank you

Kleigh

I can't tell from just your broad description. I suppose you use it whenever you want to populate the dates in textboxes. It could be anywhere in the code depending on when you want that to happen.