I'm having trouble using the after update method, to return to the original position. can anyone give a solution?
For example:
Peivate sub Cmd_Click()
Dim x as double, y as double, xy as double
X=txt1.value
Y=txt2.value
Xy=x*y
Txt1=""
End sub
Sub txt1_afterupdate()
Call Cmd_click
Txt1.setfocus
End sub
but the problem is it doesn't want to focus back on txt1
For example:
Peivate sub Cmd_Click()
Dim x as double, y as double, xy as double
X=txt1.value
Y=txt2.value
Xy=x*y
Txt1=""
End sub
Sub txt1_afterupdate()
Call Cmd_click
Txt1.setfocus
End sub
but the problem is it doesn't want to focus back on txt1