ExcelBanter - Date format textbox

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Date format textbox (https://www.excelbanter.com/excel-discussion-misc-queries/110840-date-format-textbox.html)

George

Date format textbox

I'm trying to format a textbox (in a userform) so that what ever date I write
it shows and places it in a cell as "dd-mmm-yy".
I'v tried different ways with no luck.
Please help!!!!
--
George

Kevin B

Date format textbox

You can write a OnUpdate routine using the following function

TextBox1.value = format(TextBox1.Value, "dd-mmm-yy")

--
Kevin Backmann

"George" wrote:

I'm trying to format a textbox (in a userform) so that what ever date I write
it shows and places it in a cell as "dd-mmm-yy".
I'v tried different ways with no luck.
Please help!!!!
--
George

George

Date format textbox

Thank you very much Kevin, just the job it works great
--
George

"Kevin B" wrote:

You can write a OnUpdate routine using the following function

TextBox1.value = format(TextBox1.Value, "dd-mmm-yy")

--
Kevin Backmann

"George" wrote:

I'm trying to format a textbox (in a userform) so that what ever date I write
it shows and places it in a cell as "dd-mmm-yy".
I'v tried different ways with no luck.
Please help!!!!
--
George

All times are GMT +1. The time now is 01:22 AM.