Posted to microsoft.public.excel.programming

external usenet poster

Posts: 12

Inputbox Default to be Upcomming Sunday

I have a input box that is looking for a date.

DT = InputBox("Enter New Date: ", Date)

I would like have the default value of the inputbox as the upcomming
sunday( Today is 6-29-06 default value should show 7-2-06)

Thanks in advance

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sunday	Dale[_4_]	Excel Worksheet Functions	8	November 7th 12 09:27 AM
InputBox default value?	Lunks	Excel Programming	4	May 26th 06 06:32 PM
Inputbox and Application.InputBox	Maria[_7_]	Excel Programming	1	September 20th 04 11:36 AM
Application.InputBox with Default:=0 testing False	bluhme	Excel Programming	2	June 24th 04 12:35 PM
Excel VBA - InputBox DEFAULT Value?	BruceAtkinson[_3_]	Excel Programming	3	May 26th 04 08:18 PM

All times are GMT +1. The time now is 09:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us