I'm using a table to dynamically populate a userform. It's intended to function basically the same as Excel's built-in DataForm tool, but modeless and allowing for more than 32 columns. I 'm using modified code cribbed from elsewhere so can't claim ownership nor complete understanding, but I know enough to follow the logic and understand what each piece is doing.
The table currently it looks like this (simplified):
Screenshot 2022-08-04 101031.png
Which generates this form:
Screenshot 2022-08-04 100556.png
The real table contains dozens of columns, however, and only a handful need to be edited at any given time. It's hard for my end users to scroll through the whole thing to find just the pieces they need, so I want to add categories/headings that break up the form and make it more accessible. So something like this for the table,
Screenshot 2022-08-04 101233.png
which would ideally generate a form like this (the horizontal lines are empty labels with a height of 1):
Screenshot 2022-08-04 104922.png
The current code pulls header titles from the first row of the sheet. If it makes things difficult to put the categories above the headings like in the picture, however, I'm not at all attached to it. If a lookup table or something is easier that's fine.
Sample file is attached, or the [relevant portion of] the current code is below:Thank you in advance for any advice you're able to provide.Please Login or Register to view this content.
Bookmarks