![]() |
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 |
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