assigning text box input to a sheet
 

I've got these problems::

a cmdButton on a userform should read 3 text boxes
and assign the data on one row across three columns
but I get it to do things like input into col a row1 then
b2 then c3
and worse
it should go a5 b5 c5 with existing data in a2-4 b2-4 c2-4

whn I input data data into text boxes what are the assgnments

for a start date and end date

do I dim them as strings and format them or dim them and Date and do
some other loopy assignment



I want one text box to input todays date from a text box into cell
"E2"...how do I do that ?????


any help is greatly appreciated

I should have said thanks b for the other helpo I've received

assigning text box input to a sheet
 

I want one text box to input todays date from a text box into cell
"E2"...how do I do that ?????

sheet1.range("E2").value = textbox1.value ' <== Modify Sheet & Textbox Number to suit.


wrote in message
oups.com...
I've got these problems::

a cmdButton on a userform should read 3 text boxes
and assign the data on one row across three columns
but I get it to do things like input into col a row1 then
b2 then c3
and worse
it should go a5 b5 c5 with existing data in a2-4 b2-4 c2-4

whn I input data data into text boxes what are the assgnments

for a start date and end date

do I dim them as strings and format them or dim them and Date and do
some other loopy assignment



I want one text box to input todays date from a text box into cell
"E2"...how do I do that ?????


any help is greatly appreciated

I should have said thanks b for the other helpo I've received