I have a calendar userform that enters a date into a userform textbox in the format mm/dd/yy.
I am in the UK, so default date format is dd/mm/yyyy but i need it as above - mm/dd/yy
So, when I get a MsgBox to repeat Textbox1.Value (the date from the calendar object, formatted mm/dd/yy) and repeat it in format dddd mmmm dd yyyy, it reads the value not as I want it, mm/dd/yy, but as the usual dd/mm/yyyy - so instead of reading 08/01/12 as Wednesday August 01 2012 it is giving me Sunday January 08 2012 - even though in the cells on the worksheet that are populated from the textbox, the date reads correctly, so 08/01/2012 is indeed 1st August 2012 not January 8th 2012...
So it's the MsgBOx function reading the textbox in the userform wrong, and formatting makes no difference...
Can I fix this without changing my regional settings? Is there a way to set the region in vba then unset when leaving the program? I don't want to have to change regional, and anyway, the program will be used by others who won't know / want to do that.
I have created a user form with a date field which fills a spreadsheet cell. The spreadsheet cell is formatted to dd/mm/yy but the user form will always enter as mm/dd/yy. Does anyone know how to edit the VBA form to use the dd/mm/yy format.
Trying to take data from a UserForm and copy to specific cells
It's going OK with certain fields (eg, User name) but hit a snag with the date field. The cell is formatted as *15/03/2005 in format cells, but I get odd results when a date is entered.
Initially was getting an issue with leading zeroes. If I enter 1/1/2009, this value goes into the cell as 1/1/2009, not the 01/01/2009 that I expect.....
I was using
Range("C5") = DateBox
I got round the lack of leading zeroes by pasting the actual value into the cell
Range("C5") = DateBox.Value
However, now found that I'm getting the wrong date format! If I use the first method to copy data, I'm getting UK formatting (ie enter 12/2/2008 and I get 12/2/2008), but if I use the second method, I get 02/12/2008!
I've currently got an inputbox (Userform) where the user gets to enter the date. My problem is, when the dates entered (example todays date... 17/07/06) it comes out in an error because it assumes i want the US Date format. What i would like is UK format. I've done everything i can do in excel, i assume its a problem with VBA, which i'm still thick at...
Sub proInput() Sheets(" Pivot reports"). Range("D7").Value = InputBox("Please Enter Date!")
I have an excel sheet full of dates in text format and want to convert them into regular format. For instance, one of the dates listed is in text as "60801". I'd like it to show in regular date format of mm/dd/yyyy, so that 60801 becomes 8/1/2006.
I have a Userform and 2 text boxes that require users to enter a date. I really need the users to be forced to enter the date in "mm/dd/yy" format or they cannot get passed that text box or at least an error comes up.
I've attached a picture of how my userform is set up - all of the code is working fine and does very dandy, even if I do say so myself, but as you can see when I load data into the listbox, the date on the left hand side becomes M/DD/YYYY whereas I want it as DD/MM/YYYY.
All of the columns except Due Dateconsist of text/numbers and these load fine however even if I change the format of the Due Date data within the worksheet before loading it in it still loads incorrectly. Is there any way to format the date to how I want it within the ListBox?
In D2 I have: =B2 In D3 I have manually input: (space)3-08
As you can see the CONCATENATE puts the "39569" date in A2 But the second line puts the text date as I prefer. What I would like to do is put in a formula or macro in D2 and down that will change the "Mar-08" to "3-08" so it CONCATENATEs correctly to column A. Simply: I'm trying to avoid manually inputing the text version "3-08" (or whatever M-Y) into D2 down a hundred or so rows!
I have a userfrom with 2 textboxes used for entering dates. would like to either force the user to enter the date as xx/xx/xxxx or have a calendar feature where they can select a date. I checked my 'additional controls' in my toolbox but do not see a calendar option.
However I have thirty text boxes on the Userform all linked to cells on a sheet. How do I apply this so that I dont have thirty lines of code. It just does not look elegant. I'm doing this because the number on the userform shows more decimal places than the cells format. Cell formated to 3 places Userform shows about 9 mostly .999999 etc
Is it possible to selectively format text in a textbox on a userform ie. to make some of the text bold, other parts underlined and other parts italic etc. The text which appears in my text box is entered automatically by a piece of code which extracts the contents of certain cells and arranges them in the text box as needed. I would now like to be able to display the text box with the text formatted so that its not just all in plain text.
I have a workbook that I'm using to tracking staffing patterns within a mental health agency. When the workbook opens the user is asked to pick a date range and an office location. I've placed code into the userform that pre-fills the "start date" with today's date and the "end date" 7 days from today's date. I would like the user to be able to enter a unique date range should they wish but I have yet to figure out the coding to accomplish my goal.
The idea is that the user selects a job number from combobox1 and then the appropriate column is pulled into each txt box on the form.
At the same time, I'm trying to do the same for the system time as well. Unsurprisingly I have a very similar problem here and use the same code as above. I've tried formatting both date and time txt boxes in the userform, the data transfer code etc etc with no success.
I having problem to determine the format value of dates that needs to be inserted in a Userform.
I have the following format in my userform for my Textbox:
When I select the calendar in my userform that is set as follows:
And select the first day of the month, it will always add the format as 05/01/2014 but if I select today’s date as example it will add it in the right format: 2014/05/26
I have included a sample to demonstrate the function of the calendar as I have declared it public as d in a module, therefore making the population of my userforms textbox easier to add information on dates.
If you add 2014/05/01 - 2014/05/26 and 2014/05/06 you will see where the system is having problem with the month and dates I guess the system confuses the two?
I am trying to display both text and a date in the same line. Currently I have something like ="The Date Is " & A1. where A1 is a cell with a date formatted in a preferred format. However, once I call reference to the cell, excel re-formats it into the serial date, so it displays something like. The Date Is 40220
instead of something like: The Date is 2/11/2010. Does anyone know how to format the number back into a date form? Just going through the format menus and setting it to date does not change it.
I am trying to make a very simple macro but get stuck in de Excel date format. When using the date "=TODAY()" in one cel it is no problem but I want to integrate it in the CONCATENATE function.
I want to create this text "(WG 01-01-2006)" but then with the actual date of that day of course, which can be inserted in de active cell.
Whatever I do, copy, pastespecial, reed text with RIGHT, change format on an temporary cell etc. Excel keeps returning the number in Excel date format counting from 01-01-1900. Nice for calculating but I want the date text!
I've got some data from a unix database that I have been able to import into Excel 2003. I want to use this data in an Access 2003 database but the dates are formatted all wrong. Date comes out like this "FEB08" in Excel.
I want to convert this into a date format that I can use as an actual date when I import this data into Access. I was thinking about doing the conversion in Excel before importing it into Access. If it would be easier to import into Access and then convert