Posted to microsoft.public.excel.programming

tina

external usenet poster

Posts: 139

inputbox uk date

Hi
I have a macro which request a date which is then used in an advanced filter
My problem is the date seems to be american format mm/dd/yy but i need uk
the cell g2 is formatted to dd/mm/yy but comes out as mm/dd/yy after
inputbox used
MYDATE = InputBox("ENTER DATE DD/MM/YY")
Range("G1") = "<="
Range("G2") = MYDATE
how do I format inputbox?
thanks Tina

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
InputBox a date	Otto Moehrbach	Excel Programming	6	April 12th 05 02:58 PM
Using Date in InputBox for criteria in code	SMac	Excel Programming	6	March 24th 05 07:48 PM
Inputbox to enter date	Tom Ogilvy	Excel Programming	0	July 27th 04 05:44 PM
Inputbox as Date	andibevan	Excel Programming	3	July 9th 04 02:15 PM
Date from InputBox	Michael	Excel Programming	3	May 26th 04 01:11 PM

All times are GMT +1. The time now is 06:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us