Insert textbox value into another textbox, minus characters

**crowmagnus** · 01-20-2021, 06:36 PM

I have a time stamp that puts a time stamp in a textbox in the format off "mmddyyyyhmm am/pm"
I would like to show this in another textbox without the AM/PM (If I remove the am/pm it goes to a 24hr clock which I don't want).

all I have so far is

Private Sub StartTime_Click()

    Me.TextBox1 = Format(Now(), "mmddyyyyhmm am/pm")
    Me.TextBox6 = TextBox1.Value

End Sub

**mehmetcik** · 01-20-2021, 06:50 PM

Me.TextBox6 =TEXT(TextBox1.Value, "dd/mm/yyyy" ) & " " &HOUR(TextBox1.Value)-IF(HOUR(TextBox1.Value)>12,12,0)&":" & MINUTE(TextBox1.Value)

**crowmagnus** · 01-20-2021, 06:54 PM

I'm getting a Syntax Error

**mehmetcik** · 01-20-2021, 07:00 PM

Try

Me.TextBox6 =TEXT(Me.TextBox1.Value, "dd/mm/yyyy" ) & " " &HOUR(Me.TextBox1.Value)-IF(HOUR(Me.TextBox1.Value)>12,12,0)&":" & MINUTE(Me.TextBox1.Value)

Insert textbox value into another textbox, minus characters

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Insert textbox value into another textbox, minus characters

Re: Insert textbox value into another textbox, minus characters

Re: Insert textbox value into another textbox, minus characters

Re: Insert textbox value into another textbox, minus characters

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Link Textbox to cell with more than 255 characters

[SOLVED] Excel VBA form - textbox to export data over 255 characters from textbox

[SOLVED] Can anyone tidy my Textbox minus Combobox Please?

Cut textbox string in new strings of 50 characters

[SOLVED] VBA Code for Textbox: First 3 characters Alphabets next 3 characters numeric

Textbox greater than 255 characters

Textbox: Number of Characters

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions