setfocus

I have a userform that allows me to add a new employee to a sheet, which adds some info to the sheet itself and creates a new sheet with that employees name on it. After all this process I try to setfocus back to the userform on the first text box, just by using myform.txtbox.setfocus yet it...

I have a form to populate data/dates for testing. There are two sections for testing: Test Plan Development (TPD) and System Testing (ST). Each section can have one of four statuses: Upcoming, Active, On Hold, or Complete. Each section also has a Begin Date and an End Date. The fields on...

Hi: On my worksheet (Excel 2007), the user will be entering data in both cells and combo boxes. Each time he enters info in a cell, he hits enter and the cursor moves to the next cell; however, if there is a combo box positioned over a cell, I would like the cursor to move into the combo box in...

Hello All, Thank you in advance for any help offered on this most frustrating problem. Details I have a Userform with a listview on it. The user selects a row using the Up+Down arrows, then presses Enter to add detail to that row. This shows a second userform with controls for the info. My...

I created several textboxes using the forms control. The textboxes are on a worksheet. I also have a command button that evaluates each of the entry in the textbox. When the code encounters an empty textbox, I want to bring the cursor [focus] back to the empty textbox. I don't have a...

I have an "Input data" form and all I'd like to do was to add a code so when the user press the button Ok it'd check each texbox and if it's empty show a error message and setfocus back to the empty textbox.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>...