Can someone please tell me why, when I enter 04/18 into Textbox10 as soon as I go to TextBox11, TextBox10 changes to 04/16
Like its set to automatically only display this year! grrr
![]()
Please Login or Register to view this content.
Can someone please tell me why, when I enter 04/18 into Textbox10 as soon as I go to TextBox11, TextBox10 changes to 04/16
Like its set to automatically only display this year! grrr
![]()
Please Login or Register to view this content.
Excel sees 04/18 as 18 April 2016, if you only want to enter a month and year perhaps you could use another approach eg spin buttons, comboboxes.
If posting code please use code tags, see here.
So there is no format for month/year ? its for a credit card expiration date..
For anyone curious I ended up just going with the text format
![]()
Please Login or Register to view this content.
Do you need to format the value in the textbox as text, it is text after all?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks