sjohnp2112
03-08-2017, 01:19 PM
Well I thought this would be easy, sort of, but....
I have a worksheet, and column A with a range of 29 cells (A2:A30) containing expense category names for a budget workbook, and range A30 is called
"Totals" which represents the totals row that sums daily transactions. I have a userform that populates textboxes with the values in column A, but I want to exclude the value "TOTALS" or at least set its Textbox.Text = "N/A".
This would work great if the transaction worksheet was set have no more and no less than 29 rows, but I made it so users can insert/delete rows as they wish. One user might tailor his budget workbook to track only 10 expense categories where someone else may want to track 20+; therefore the "TOTALS" row is not fixed. I tried variations of loops, arrays and such and got nowhere. I don't think it should be that difficult but I'm still new at this so thanks for patience....any help would be much appreciated.
thanks,
sjohnp2112
I have a worksheet, and column A with a range of 29 cells (A2:A30) containing expense category names for a budget workbook, and range A30 is called
"Totals" which represents the totals row that sums daily transactions. I have a userform that populates textboxes with the values in column A, but I want to exclude the value "TOTALS" or at least set its Textbox.Text = "N/A".
This would work great if the transaction worksheet was set have no more and no less than 29 rows, but I made it so users can insert/delete rows as they wish. One user might tailor his budget workbook to track only 10 expense categories where someone else may want to track 20+; therefore the "TOTALS" row is not fixed. I tried variations of loops, arrays and such and got nowhere. I don't think it should be that difficult but I'm still new at this so thanks for patience....any help would be much appreciated.
thanks,
sjohnp2112