Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning a number value to text | Excel Worksheet Functions | |||
assigning numbers to text and count the text | Excel Discussion (Misc queries) | |||
IF Then using a column of text and assigning a number to text | Excel Discussion (Misc queries) | |||
Input box and assigning to a variable. | Excel Programming | |||
2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions |