dart-player
New Member
- Joined
- Jan 1, 2014
- Messages
- 5
want this function on a UserForm ,
insertion of new ROW in the sheet by clicking the button ( it works )
Now comes the desire
1 Text box Tournament series ( Entire Column A )
2 Text box Matchnumber . ( Entire column B)
3 Text Box of date . ( Entire Column C )
4 Text box for Start time of the match. (Entire Column D )
5 Text box for the home team . ( Entire column E )
6 Text box for the team . (Entire Kolone F)
all on same sheets
when data is entered in
"1" should Be Stay showed in textbox until new data type or reset.
"2" must have the feature that if write 52000 and click on
insert a new row . would the new Row called 52001 etc etc
"3" only be referenced to the cell in Row
"4" only be referenced to the cell in Row
" 5 " is Becoming until new data is written or reset
" 6 " is Becoming until new data is written or reset
The first row would look like before insert new line.
" Division 1 ", " 52000 ", " 01-07-2014 ", " 19:30 ", "Home " , "Out " click on new line
Then by entering this above and click
" Division 1 ", " 52001 ", " 01-07-2014 ", " 19:30 ", "Home " , "Out " click on new line
Then by entering this above and click
" Division 1 ", " 52002 ", " 08-07-2014 ", " 19:30 ", "Home " , "Out " click on new line
Then by entering this above and click
" Division 1 ", " 52003 ", " 08-07-2014 ", " 19:30 ", "Home " , "Out " click on new line
Then by entering this above and click
" Division 1 ", " 52004 ", " 15-07-2014 ", " 19:30 ", "Home " , "Out " click on new line
Then by entering this above and click
and finally might look like this
" Division 4 ", " 56000 ", " 01-07-2014 ", " 19:30 ", "Home " , "Out " click on new line
and it's all done on a UserForm we textboxes
insertion of new ROW in the sheet by clicking the button ( it works )
Now comes the desire
1 Text box Tournament series ( Entire Column A )
2 Text box Matchnumber . ( Entire column B)
3 Text Box of date . ( Entire Column C )
4 Text box for Start time of the match. (Entire Column D )
5 Text box for the home team . ( Entire column E )
6 Text box for the team . (Entire Kolone F)
all on same sheets
when data is entered in
"1" should Be Stay showed in textbox until new data type or reset.
"2" must have the feature that if write 52000 and click on
insert a new row . would the new Row called 52001 etc etc
"3" only be referenced to the cell in Row
"4" only be referenced to the cell in Row
" 5 " is Becoming until new data is written or reset
" 6 " is Becoming until new data is written or reset
The first row would look like before insert new line.
" Division 1 ", " 52000 ", " 01-07-2014 ", " 19:30 ", "Home " , "Out " click on new line
Then by entering this above and click
" Division 1 ", " 52001 ", " 01-07-2014 ", " 19:30 ", "Home " , "Out " click on new line
Then by entering this above and click
" Division 1 ", " 52002 ", " 08-07-2014 ", " 19:30 ", "Home " , "Out " click on new line
Then by entering this above and click
" Division 1 ", " 52003 ", " 08-07-2014 ", " 19:30 ", "Home " , "Out " click on new line
Then by entering this above and click
" Division 1 ", " 52004 ", " 15-07-2014 ", " 19:30 ", "Home " , "Out " click on new line
Then by entering this above and click
and finally might look like this
" Division 4 ", " 56000 ", " 01-07-2014 ", " 19:30 ", "Home " , "Out " click on new line
and it's all done on a UserForm we textboxes
Last edited: