Michael Simpson
Board Regular
- Joined
- Jun 21, 2010
- Messages
- 232
At the moment, I'm not after any actual code (though that may well change
). I'm more after ideas on a best way to solve a problem. I'm an average VBA programmer (amazing what you can find by googling), but one thing I've learnt with VBA/Excel is it's your imagination that is often the limiter. Anyway - to my design problem.
You have a bunch of parent rows where each one could contain one or more child rows. Generally, the user will want to review the parents, and then might want to drill down and review the children. I've come up with a couple of designs at the moment.
All the rows on one sheet, children hidden. Some sort of toggle that shows/hides the children. Question - will you need one toggle for EACH parent, or can you have a general toggle that then interprets where the cursor is and toggles accordingly ? (... and how would you solve the toggle button being, say, on row 1 and the row they want to toggle is a couple of pages down ?)
You have all the parents on one sheet, and the parents/children (all) shown on the second sheet. The user places focus on the parent on sheet 1 and presses "something", whereupon the code performs a "hyperlink" to the correct row on the second sheet. Question - how difficult to build, and what solution to "go back" to the correct parent on the first sheet ?

You have a bunch of parent rows where each one could contain one or more child rows. Generally, the user will want to review the parents, and then might want to drill down and review the children. I've come up with a couple of designs at the moment.
All the rows on one sheet, children hidden. Some sort of toggle that shows/hides the children. Question - will you need one toggle for EACH parent, or can you have a general toggle that then interprets where the cursor is and toggles accordingly ? (... and how would you solve the toggle button being, say, on row 1 and the row they want to toggle is a couple of pages down ?)
You have all the parents on one sheet, and the parents/children (all) shown on the second sheet. The user places focus on the parent on sheet 1 and presses "something", whereupon the code performs a "hyperlink" to the correct row on the second sheet. Question - how difficult to build, and what solution to "go back" to the correct parent on the first sheet ?