formatting dates and times in visual basic

[station manager]

I am a real rookie with VB but moving along pretty well. I am building a form and I want to create a drop down box where users can select a date from a calendar. Every time I try to build some sort of cell range it returns the decimal in the VB box. Thanks in advance for your help.

 

[Ivan F Moala]

On 2002-04-04 18:58, station manager wrote:
I am a real rookie with VB but moving along pretty well. I am building a form and I want to create a drop down box where users can select a date from a calendar. Every time I try to build some sort of cell range it returns the decimal in the VB box. Thanks in advance for your help.

Try

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

Lookup Format while in the VBA Editor