mykulpasskwa
Board Regular
- Joined
- Mar 20, 2018
- Messages
- 66
Long story short I'm still about one years old using VBA and I'm making a spreadsheet with multiple semesters in column A. In column B is tuition, and in column C is fees. I just started making this so I haven't gotten very far, but I currently have it set up where when you click on cell C1 a userform ("Fees Form") appears and there's 8 text boxes that adds different fees together. I have the inputs stored out-of-sight in individual cells so that the fees will load each time the form is opened for that semester. I only have this set up for one cell so far, but I was wondering how to best execute this across many semesters. So the next semester would be in C2, the next C3, so on and so forth. Can I use one form ("Fees Form") and when I click on a specific row (say C2) it will load a that semesters fees, and if I click on a different row (C3) then it will load that semesters fees? Or do I need to use a different form for each semester?
Because I will need a form to calculate tuition, another form to calculate scholarships, another for grants, another for xyz...it looks like I'll need somewhere between 36-48 forms if I need a different form for each category in each semester. This doesn't seem practical to me and also I'm not sure how excel will handle it. Any thoughts?
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Because I will need a form to calculate tuition, another form to calculate scholarships, another for grants, another for xyz...it looks like I'll need somewhere between 36-48 forms if I need a different form for each category in each semester. This doesn't seem practical to me and also I'm not sure how excel will handle it. Any thoughts?
A | B | C | |
Semester | Tuition | Fees | |
1 | Fall | 1000 | 100 |
2 | Spring | 2000 | 200 |
3 | Summer 1 | 3000 | 300 |
4 | Summer 2 | 4000 | 400 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>