Copy Record.xlsb
I have a excel userform with data field loan and return date time (textbox 7 & 8).
how can I show the field in textbox and listbox with both date and time as shown in "data" sheet col. H & I, i just can show the date only right now
please help
Add the code below to format your textboxes (you may need to change the format to your locale settings)
Please Login or Register to view this content.
Add the following five rows to CommandButton9 and also to the Initialize event immediately following the listbox load and to any other Sub that you use to load the listbox.
please place all your declared variables immediately after Option Explicit - then run debug and correct all the errors that show.Please Login or Register to view this content.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
thz for your help.
but how about the listbox? it still no time inside listbox
Get rid of your UserForm_Activate event it is overriding the Initialize events and cancelling out the format.
Get rid if your present CommandButton9_Click event and Your Initialize event - then copy/paste the code below - one Sub LOADLIST() is called from the initialize and also if you click Command9
Please Login or Register to view this content.
thz so much it ok now
you are great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks