yyyy

  1. A

    Displaying dd mmm yyyy

    I'm connecting to Excel 2003 from Access 2007 to populate a worksheet created by a 3rd party program. From Access I send xlSh.Cells(iRow, 11).Value = Day(Now) & " " & MonthName(Month(Now), True) & " " & Year(Now) This should result in dd mmm yyyy but Excel shows this as dd-mmm-yy I guess...
  2. kelly mort

    Converting a listbox column from text format to date format

    I have this line here: My listbox is povulated by the .Text format. Now I wanna get the contents in the 4th column back to the date format and display only the year in a textbox. I used the code below but I got some strange result. My dates are like this in the worksheet : DD-MM-YY. And I want...
  3. R

    VBA - Change Access date format to custom

    Hello, I am currently using a macro to copy data from Excel to an Access database. There are some fields that i need to have in access as "mmmm yyyy" (Ex: December 2016) but access seems to be ignoring my attempts to change the data format. My code is the following for the VBA query: (...)...
  4. G

    Table Data from userform??

    Hi, I have a table in a worksheet and a userform that colects the data from the table using vlookup, if i change the data on the userform how can i send it back to the table just using the userform???????? Here is what i have so far Private Sub ComboBox1_dropbutt*******() On Error Resume...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top