About Us

DEFJ

works like a charm-

thnx

-----Original Message-----
one way:

Dim result As Variant
Do
result = Application.InputBox("Enter date:",
Type:=2)
If result = False Then Exit Sub 'User clicked
Cancel
Loop Until IsDate(result)
result = CDate(result)

In article ,
"defj" wrote:

How would I get an inputbox variable to be returned as
a
date? I want the user to input a date...the date is
then
compared with a list of other dates until the program
finds a date greater than the one entered. The
inputbox
returns a string so it won't compare the variable with
the
list of dates. Is there a way to convert a string to a
date?
.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
InputBox with VBA	Mark[_8_]	Excel Discussion (Misc queries)	0	November 24th 08 12:39 AM
InputBox	peyman	Excel Discussion (Misc queries)	4	September 28th 07 04:53 PM
InputBox	GeorgeJ	Excel Discussion (Misc queries)	5	July 12th 07 01:20 AM
inputbox	brownti via OfficeKB.com	Excel Discussion (Misc queries)	2	February 9th 07 02:37 PM
Inputbox with VBA	Jeff	Excel Discussion (Misc queries)	3	January 19th 06 05:18 PM

Menu

About Us