Copy/Paste command on a form

[Brando]

Copy/Paste

I have a textbox on a form that automatically shows the current date. Below that, I have 3 other textboxes for dates (each representing a step in a process). Often, the same date is imputed into each of these boxes. I would like to have an “Autofill” command button that would take the date in the first box and place it in the other three. This is so basic it’s hard. My usual searches turn up nothing. Any suggestions welcome.

 

[Carl Foster]

Try this code in the VB editor of your button click event:

Dim strCopiedText as String
strCopiedText = txtBox1
txtBox2 = strCopiedText

End Sub

Just substitute the "txtBox1" and "txtBox2" with the names of your 2 text boxes.

 

[Brando]

That did it! Thank you so much!

 

[Carl Foster]

My Pleasure

 

[ghudson]

Why not simplify it to just the basics?

txtBox2 = txtBox1

 

[Carl Foster]

True, I do tend to complicate things, sorry