J
John Michl
I have a budgeting template that contains several dozen potential line
items of which only ten or so might be used on a given model. I'd like
to build a series of UserForms that would prompt the user to select the
line items that should be shown (assuming the others are hidden). Due
to the format of the sheet, I don't want to use DataFilters.
I'm not quite sure how to approach this since I don't have a lot of
UserForm experience. Therefore, any direction and sample code would be
appreciated. I was thinking something like the following.
Any comments on this approach? How about examples and/or alternatives.
- John
items of which only ten or so might be used on a given model. I'd like
to build a series of UserForms that would prompt the user to select the
line items that should be shown (assuming the others are hidden). Due
to the format of the sheet, I don't want to use DataFilters.
I'm not quite sure how to approach this since I don't have a lot of
UserForm experience. Therefore, any direction and sample code would be
appreciated. I was thinking something like the following.
Any comments on this approach? How about examples and/or alternatives.
- John