Setting focus on a textbox in userform on Excel VBA

Hi Mahaveer,

Sorry, I thought I replied to you, but I must have forgotten. I tried what you did, but what I attached was only part of my project. I actually need to be able to call frmOther when the user choose the "Other" choice in the userform frmTradeSickOther.

Here is a summary of my entire project:

• At my workplace, we currently have our schedule on paper. My boss makes my schedule on excel and then prints out and posts it.
• The employees make trades with each other all the time. To do this, we put in a request by filling out a form and submitting it to my boss and she makes the change.
• Employees aren't allowed to make changes, unless if someone calls in sick in the middle of the night or weekends when the bosses aren't around.
• I give each employee an account within the excel file. When they make changes to any cell, they'll be promted by the userform frmTradeSickOther. Each choices in this userform will call frmTrade, frmSick and frmOther, where the user will fill out the mandatory information. When the user clicks on "Add Comment" button on each userform, it will consolidate the information into a sencence and add it as a comment to the cell that is being changed. The comment will also include the name of the user that made the change, time and date of the
• Bosses are able to turn off the mandatory comment function, but employees aren't allowed to do so.
• Employees aren't allowed to print out the schedule as well to save paper and the environment. They can just e-mail the file to themselves and view it at home when needed.

I am new to VBA. This is actually my first time working on it. Someone from YahooAnswers! had helped me with everything, but now he doesn't have time to help due to his work. So, I have been building on what he did.