I have started a userform and I am having some problems. So far
I have 2 command buttions that allow the user the change the direction of the cell on enter.
This code is in the userform location
I also have a code to open the userform when the wookbook opens.
I have this in the "ThisWorkBook" location.
The code seem to work but it will not allow me to return back the worksheet, it seems to "lock up". I have to exit the userform to get back to the worksheet. I want to leave the userform open.
I tried selecting the worksheet but did not have any luck.
What am I doing worng?
Thank you.
Steve
I have 2 command buttions that allow the user the change the direction of the cell on enter.
This code is in the userform location
Code:
Private Sub CommandButton1_Click()
Application.MoveAfterReturnDirection = xlToRight
End Sub
Private Sub CommandButton2_Click()
Application.MoveAfterReturnDirection = xlDown
End Sub
I also have a code to open the userform when the wookbook opens.
Code:
Private Sub Workbook_Open()
UserForm1.Show
End Sub
I have this in the "ThisWorkBook" location.
The code seem to work but it will not allow me to return back the worksheet, it seems to "lock up". I have to exit the userform to get back to the worksheet. I want to leave the userform open.
I tried selecting the worksheet but did not have any luck.
What am I doing worng?
Thank you.
Steve