Objects and Arrays

[ronaldk]

I have a form with 5 textboxes below each other and next to each textbox a button that removes the values in that textbox and hides the last textbox (creating the impression that that row is deleted and the other rows jumped one up).

If textbox1 is removed my code reads:

Please Login or Register  to view this content.

You can see that this code gets very long when there is more than 1 textbox in a row and a number of rows.

Surely there must be a shorter way. Could any of the smart men help this fool? (The values of the textboxes are stored on a sheet.)

[pike]

Hi ronaldk
can you explain a little more on why you have this set up?

[ronaldk]

It is a little calculator that I built for financial advisors.
Attached please find the form.
I just feel I should be able to use loops in some way.

[shg]

Maybe like this (untested):

Please Login or Register  to view this content.