Excel Version 2010
I am using VBA to input a time stamp into an activeX textbox. Following is code:
'Time stamp command button.
CurTime = Format(Now(), "hh:mm" & " - ")
TextBox1.Text = TextBox1.Text & CurTime
Issue is that once time stamp is inserted you must click back into the box to type anything further. My preference is that you could start typing immediately but I can see no way to enable that. I have another section with a merged cell and by simply using Sendkeys F2 issue is resolved there but does not work in activeX textbox. The activeX textbox is inserted onto a worksheet and is not in a form.
Thank you in advance for any assistance you may have to offer.