<div>
You would use the SelStart and SelLength properties to position the cursor.<br />
<br />
In the OnEnter or GotFocus event, do:<br />
<br />
&nbsp; &nbsp;Me.txtLastName.SelStart = Len(Me.txtLastName)<br />
&nbsp; &nbsp;Me.txtLastName.SelLength = 0<br />
<br />
Jim.
</div>


<div>
Thank &nbsp;you for your comment. The TextBox (in my case txtFirstName or txtLastName) does not seem to have GotFocus or OnEnter events. <br />
I am using these text boxes on an Excel VBA form.
</div>


FaheemAhmadGul

<div>
The TextBox does not have EnterFieldBehavior either
</div>


TextBox.jpg

<div>
You can simply use the Enter event<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42992472-1"><span>Private Sub txtLastName_Enter()</span>
<span>    With Me.txtLastName</span>
<span>        .SelStart = Len(.Value)</span>
<span>        .SelLength = 0</span>
<span>    End With</span>
<span>End Sub</span>
</code></pre>
</div>


<div>
Thank you very much all for your very helpful comments which have completely answered my question. All the comments helped my understanding of VBA. Comment from Flyster which came last night was a complete solution though I am sorry I could not understand it last night how to implement that, but Neeraj’s screen shot has helped me understand what I needed to do. <br />
Thank you very much once again for all your help. Greatly appreciated.
</div>


<div>
You're welcome Faheem! Glad we could help.
</div>


<div>
Sorry for the delay, but I have a got focus event here:<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2019/12_w50/1438499/Region-Capture.jpg" target="_blank" title="Region-Capture.jpg (75 KB)"><img alt="Region-Capture.jpg" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2019/12_w50/800_1438499/Region-Capture.jpg" /></a><br />
Jim.
</div>


Region-Capture.jpg

<div>
You're welcome Faheem! Like Subodh, I did have a screenshot, I just forgot to post it!! Glad you got it working.
</div>


<div>
<div class="content wysiwyg-content">
On a VBA user Form I have two Text Boxes (named txtFirstName and txtLastName) and I frequently need to tab from one to another. <br />
<br />
Currently when I tab from textbox to another all the text in the next Text Box gets selected. I would like to be able to tab to the next text box such that after pressing the tab key the <b>cursor is at the of all the text in next TextBox</b>. <br />
<br />
I would appreciate help with how I set the properties of these Text Boxes so I achieve the above objective - that is after pressing the tab key when I get into the next textbox the cursor is at the end of all the text in the next text box. <br />
If there is any VBA code which could enable such behaviour I would appreciate help with that also. Thanks. <br />
I include an image to show what I am getting now and how I would like it to be. <br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2019/12_w49/1438449/TextBoxExample.png" target="_blank" title="Sample Image (7 KB)"><img alt="Sample Image" class="file-block lazyload" style="max-width: 631px;" data-src="https://filedb.experts-exchange.com/incoming/2019/12_w49/1438449/TextBoxExample.png" /></a>
</div>
</div>


TextBoxExample.png

On a VBA user Form I have two Text Boxes (named txtFirstName and txtLastName) and I frequently need to tab from one to another. 

Currently when I tab from textbox to another all the text in the next Text Box gets selected. I would like to be able to tab to the next text box such that after pressing the tab key the cursor is at the of all the text in next TextBox. 

I would appreciate help with how I set the properties of these Text Boxes so I achieve the above objective - that is after pressing the tab key when I get into the next textbox the cursor is at the end of all the text in the next text box. 
If there is any VBA code which could enable such behaviour I would appreciate help with that also. Thanks. 
I include an image to show what I am getting now and how I would like it to be. 



VBA Code - How to tab from one TextBox to another so that after tabing the cursor is at the end of all the text in the next TextBox

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.