Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create column & Row in userfrom
hi,
is there any way in userfrom i can create a 4 column & 5 rows where i can add data into that and it should be transfer into sheet1. and when i add new data it should go to next row and can i recall data from sheet1 and make change on it and it should be save in that row only. hope any one can give me the way? thanks in advance. sd shah |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
create column & Row in userfrom
You could do it by adding an array of textboxes/comboboxes on your userform
and writing the code to populate the textboxes and update the worksheet with changes made in the text boxes. A more standard approach might be to have one row of textboxes (4 ) and work one row at a time. You might want to peruse these articles: http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm Lesson 11: Creating a Custom Form Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step. http://support.microsoft.com/default.aspx?kbid=161514 XL97: How to Use a UserForm for Entering Data http://support.microsoft.com/default.aspx?kbid=213749 XL2000: How to Use a UserForm for Entering Data Regards, Tom Ogilvy "sd" wrote in message ... hi, is there any way in userfrom i can create a 4 column & 5 rows where i can add data into that and it should be transfer into sheet1. and when i add new data it should go to next row and can i recall data from sheet1 and make change on it and it should be save in that row only. hope any one can give me the way? thanks in advance. sd shah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I update a column and create new rows for new column cells | Excel Discussion (Misc queries) | |||
how do I create multiple column width in the same column in excel | Excel Discussion (Misc queries) | |||
Userfrom problem... | Excel Discussion (Misc queries) | |||
How do you use DTpicker in a Userfrom | Excel Discussion (Misc queries) | |||
can you use the dtpicker in an userfrom | Excel Worksheet Functions |