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 |
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 |
All times are GMT +1. The time now is 07:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com