Hi,
I have a UserForm which displays the dates in my spreadsheet in the (MM/DD/YYYY) format. The dates are stored in my spreadsheet as (DD/MM/YYYY).
I want my UserForm to display the dates in the (DD/MM/YYY) format.
Below is my code, everything else works correctly. Can anyone suggest a fix?
Text Box 7, 16, 17, 30, 32, 34, 36, 38, 40, 41, 42 are those with dates in them.
Please Login or Register to view this content.
Hi,
Please upload the workbook so that we can see the request in context.
In addition have you considered simplifying that code with a loop that processes from 1-43?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi, here is a condensed version of my Userform/spreadsheet.Originally Posted by Richard Buttrey
As you can see, the date is displayed as 08/01/1987, but in the UserForm it is displayed as 01/08/1987, how can i display it as 08/01/1987 in the UserForm?
Thanks
Hi,
In the ComboBox1_Change event change TextBox7 to
TextBox7 = Format(MyRange.Find(ComboBox1).Offset(0, 8), "dd/mm/yyyy")
Thanks very much, that worked perfectly, greatly appreciated.
Hello David
You might like to consider simplifying this. As I intimated a loop would be better used to populate your text boxes
I alos see that every time you populate them you are calling the Function MyRange. Which means that you are calling it 43 times. Which is rather a waste of time and resources.
Just create an Excel dynamic range name called 'MyRange'
=OFFSET(Plan!$A$2,0,0,COUNTA(Plan!$A:$A),1)
Create a Public Variable in the VBA
In your Userform initialise eventPlease Login or Register to view this content.
and now your ComboBox change event isPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Richard Buttrey; 08-27-2012 at 10:43 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks