?
Solved

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

Posted on 2012-03-15
3
Medium Priority
?
303 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 750 total points
ID: 37724100
0
 
LVL 6

Assisted Solution

by:Peter Kiprop
Peter Kiprop earned 750 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

718 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