Solved

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

Posted on 2012-03-15
3
294 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
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Some time ago I was asked to create a VBA function that would calculate a check digit for an input number, using the following procedure: First, sum up all the individual digits in the number If that sum value has more than one digit, then sum up …
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

839 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