Solved

How can I move from TextBox1 to TextBox2 after data has been entered from code?

Posted on 2012-03-15
3
297 Views
Last Modified: 2012-03-18
I'm trying to move the cursor from TextBox1 which has the date from a userform "Calendar". I wish to move to "TextBox2" where data is manually entered. Attached is the latest test workings which work well except I can't go to TextBox2 without using the "ENTER" or "TAB" keys. Can anyone assist me with code to move the cursor?
Tab-Test.xlsm
0
Comment
Question by:user2073
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 17

Accepted Solution

by:
selvol earned 250 total points
ID: 37724100
0
 
LVL 6

Assisted Solution

by:Peter Kiprop
Peter Kiprop earned 250 total points
ID: 37724153
Check the attached it should work
Tab-Test.xlsm
0
 

Author Closing Comment

by:user2073
ID: 37736287
This solution was helpful but I needed more details. As a result I eventually found the solution required. Thanks for your guidence your support is appreciated.
0

Featured Post

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question