Help with adding and deleting rows using VBA

[skonduru]

Hi All,

Can anyone help me with the following issue:

I created a activex text box control in sheet1, which asks for the integer entry. Based on e entry, I want to delete rows, add rows and update ranges in sheet1. To be specific, Say If I enter 4 in textbox control, I want to inert 4 rows from Row 9 and name it as Range 1. If I change the number to 3 in textbox control, I want to delete the range1 and insert 3 rows and rename range as Range1(Same name) and so on. Similary i have to do for other ranges too, so, if anyone can help me to start with, I can carry on the procedure for creating other ranges.

I was able to come up with a code for inserting n sheets based on the textbox value change. I wrote all this code in txtbox_change event. Because all the above procedure will based on value change.

PLease find the attached to see what i am talking about. Range1 is CaissonGeometry

Any help will be appreciated a lot.

Thanks,

Kon.

[skonduru]

Can anyone please help me with the above issue....