create column & Row in userfrom

[sd]

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

 

[Tom Ogilvy]

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