Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter date in text box - copy to worksheet cell
I need to enter a date in a text box in the format:
day, month and year using numerical values. e.g. 15/07/2005. On clicking the ok button on the form the values need copied to a worksheet cell. I have written code to achive this but I keep incountering a frustrating problem in that excel insists that if the day value is twelve or less then this should be the month value and the program transposes the values. Thanks in advance. Francis Brown |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter date in text box - copy to worksheet cell
Answer in earlier thread.
"Francis Brown" wrote: I need to enter a date in a text box in the format: day, month and year using numerical values. e.g. 15/07/2005. On clicking the ok button on the form the values need copied to a worksheet cell. I have written code to achive this but I keep incountering a frustrating problem in that excel insists that if the day value is twelve or less then this should be the month value and the program transposes the values. Thanks in advance. Francis Brown |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter date in text box - copy to worksheet cell
Better answer provided - check it out.
-- Regards, Tom Ogilvy "Francis Brown" wrote in message ... Answer in earlier thread. "Francis Brown" wrote: I need to enter a date in a text box in the format: day, month and year using numerical values. e.g. 15/07/2005. On clicking the ok button on the form the values need copied to a worksheet cell. I have written code to achive this but I keep incountering a frustrating problem in that excel insists that if the day value is twelve or less then this should be the month value and the program transposes the values. Thanks in advance. Francis Brown |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter number on a worksheet to copy row from another worksheet | Excel Worksheet Functions | |||
Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
Copy text from text box to cell in another worksheet | Excel Worksheet Functions | |||
How to copy text box from one worksheet to cell | Excel Worksheet Functions | |||
How do I copy a date in a worksheet cell to another worksheet? | Excel Worksheet Functions |