I'm in the process of trying to teach myself arrays...
for the most part i've been using cells in a worksheet to handle what i want to do...but i want to try and avoid using the worksheet...i'm assuming arrays would be the best replacement...
here's essentially what i want to try and accomplish...
1) enter data into an input box on a form and store it based upon one of 4 buttons i press....essentially i had 4 columns on the sheet and found the last row and stored the data in 1 row offset....assume for each command button that right(commandbutton,1) = 1, 2, 3, 4 to identify which column to store the data...
2) how do i declare the multidimensioned array especially since it will be dynamic in row size...the column size will always be the same...
3) any other basic info that may help me...
thanks for any help in getting me up to speed in arrays...
for the most part i've been using cells in a worksheet to handle what i want to do...but i want to try and avoid using the worksheet...i'm assuming arrays would be the best replacement...
here's essentially what i want to try and accomplish...
1) enter data into an input box on a form and store it based upon one of 4 buttons i press....essentially i had 4 columns on the sheet and found the last row and stored the data in 1 row offset....assume for each command button that right(commandbutton,1) = 1, 2, 3, 4 to identify which column to store the data...
2) how do i declare the multidimensioned array especially since it will be dynamic in row size...the column size will always be the same...
3) any other basic info that may help me...
thanks for any help in getting me up to speed in arrays...