formatting dates and times in visual basic

station manager · Apr 4th, 2002, 07:58 PM

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 · Apr 4th, 2002, 10:41 PM

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 07:58 PM	#1
station manager New Member Join Date: Apr 2002 Location: West Virginia Posts: 2	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.