Prev: Help with SORT property in xl2007 and xl2007 !!!!!!!!!!!!!!!!!!!!
Next: Help with SORT property in xl2007 and xl2007 !!!!!!!!!!!!!!!!
From: Bobby on 28 Apr 2010 16:24 On Apr 28, 3:39 pm, Mike <M...(a)discussions.microsoft.com> wrote: > TRY THIS > Private Sub UserForm_Initialize() > TextBox3.SetFocus > End Sub > > > > "Bobby" wrote: > > Hi, > > Could someone tell how to initialize or place the cursor in a specific > > box on a userform, when I open the userform containing 4 text boxes. > > By default it goes in the first one. > > > Thank's ahead. > > .- Hide quoted text - > > - Show quoted text - Rick, to apply your recommandation regarding the usage of the group, there are 3 buttons: Reply Reply to author Forward Which one should I use? Regarding my last question, there no need for validation in this Userform. Just an assignment to specific cell. Thank's and regards.
From: Rick Rothstein on 28 Apr 2010 16:35
"Bobby" <rpqcca(a)gmail.com> wrote in message news:7f27fea6-17d9-4101-a5fe-a8e23dc5e8ff(a)j15g2000vbq.googlegroups.com... > On Apr 28, 3:39 pm, Mike <M...(a)discussions.microsoft.com> wrote: >> TRY THIS >> Private Sub UserForm_Initialize() >> TextBox3.SetFocus >> End Sub >> >> >> >> "Bobby" wrote: >> > Hi, >> > Could someone tell how to initialize or place the cursor in a specific >> > box on a userform, when I open the userform containing 4 text boxes. >> > By default it goes in the first one. >> >> > Thank's ahead. >> > .- Hide quoted text - >> >> - Show quoted text - > > Rick, to apply your recommandation regarding the usage of the group, > there are 3 buttons: > > Reply Reply to author Forward > > Which one should I use? > > Regarding my last question, there no need for validation in this > Userform. Just an assignment to specific cell. > Thank's and regards. In that case, I would just assign the TextBox's ControlSource property to the cell you want to display the text in. You will find the ControlSource property in the Project Properties window... just select the TextBox first, then type in the address (along with its worksheet) in the space to the right of the ControlSource property; for example, Sheet3!H7. You can do that for each TextBox (using a different cell address, of course)... then, when the user hits the Enter key or moves the focus to another control, the text in the TextBox will be entered into the specified cell. -- Rick (MVP - Excel) |