ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Refedits / Autotab (https://www.excelbanter.com/excel-programming/393549-refedits-autotab.html)

JT

Refedits / Autotab
 
I have 3 RefEdits on a form. The user will select a different cell for each
RefEdit.

Currently the user has to select each RefEdit to select a cell.

Is there a way to automatically tab to the next RefEdit control once the
user selects a cell?

The tabs are set up correctly, so that when the form is opened, I can tab
through the controls in the correct order.

Any help would be greatly appreciated.....Thanks
--
JT

John Bundy

Refedits / Autotab
 
Just set the change method
Private Sub RefEdit1_Change()
RefEdit2.SetFocus
End Sub
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"JT" wrote:

I have 3 RefEdits on a form. The user will select a different cell for each
RefEdit.

Currently the user has to select each RefEdit to select a cell.

Is there a way to automatically tab to the next RefEdit control once the
user selects a cell?

The tabs are set up correctly, so that when the form is opened, I can tab
through the controls in the correct order.

Any help would be greatly appreciated.....Thanks
--
JT



All times are GMT +1. The time now is 11:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com