sorry to ask such a basic question but I can't find the answer anywhere. When you use FORM on the DATA menu to enter information, it automatically moves to the next line when you hit 'NEW' How does that work when you use the data entry tools on the FORMS toolbar? I can populate a specific cell with data from text entry box, or a true or false from a tick box or from a pull dowm. But I can't see how to apply that data to columns in one row and then move to the next row. for instance, heres a vastly simplified version of what I need to end up with: name/ start date/ probation completed/ probation passed or failed/ team john 11/11/07 yes passed blue bill 12/1/06 no n/a red pete 3/4/07 yes failed green and I want a form that will populate this type of table using pull downs and tick boxes rather than needing the text typed in full each time. I'm missing something crucial I guess but I can't see what! regards jc
You have to write event code for the control to transfer the data from the control to the cell on the worksheet. expl: Private Sub CommandButton1_Click() Sheets(1).Range("A1") = Me.TextBox1.Text End Sub This code assumes a UserForm with a TextBox and a CommandButton. Data entered into the TextBox will be copied to cell A1 of sheet 1 when the button is clicked. To move it down a row each time you alter the code like: Private Sub CommandButton1_Click() If x < 1 Then x = 1 Sheets(1).Range("A" & x) = Me.TextBox1.Text x = x + 1 End Sub Each time you click the button, x will increment by 1 and advance the row number for the next entry. This is a simplistic illustration. The actual code would depend on individual requirements. "merlin777" wrote: > sorry to ask such a basic question but I can't find the answer anywhere. > > When you use FORM on the DATA menu to enter information, it automatically > moves to the next line when you hit 'NEW' > > How does that work when you use the data entry tools on the FORMS toolbar? I > can populate a specific cell with data from text entry box, or a true or > false from a tick box or from a pull dowm. But I can't see how to apply that > data to columns in one row and then move to the next row. > > for instance, heres a vastly simplified version of what I need to end up > with: > > name/ start date/ probation completed/ probation passed or failed/ > team > john 11/11/07 yes passed > blue > bill 12/1/06 no n/a > red > pete 3/4/07 yes failed > green > > and I want a form that will populate this type of table using pull downs and > tick boxes rather than needing the text typed in full each time. > > I'm missing something crucial I guess but I can't see what! > > regards > jc > > > >
Code can also be written for a textbox from the forms toolbar on a worksheet to accomplish the same results, but the process is different from using the UserForm and my personal preference is to use controls from the Control Toolbox rather than from the Forms Toolbar. "merlin777" wrote: > sorry to ask such a basic question but I can't find the answer anywhere. > > When you use FORM on the DATA menu to enter information, it automatically > moves to the next line when you hit 'NEW' > > How does that work when you use the data entry tools on the FORMS toolbar? I > can populate a specific cell with data from text entry box, or a true or > false from a tick box or from a pull dowm. But I can't see how to apply that > data to columns in one row and then move to the next row. > > for instance, heres a vastly simplified version of what I need to end up > with: > > name/ start date/ probation completed/ probation passed or failed/ > team > john 11/11/07 yes passed > blue > bill 12/1/06 no n/a > red > pete 3/4/07 yes failed > green > > and I want a form that will populate this type of table using pull downs and > tick boxes rather than needing the text typed in full each time. > > I'm missing something crucial I guess but I can't see what! > > regards > jc > > > >
