business_analyst
Board Regular
- Joined
- Jun 5, 2009
- Messages
- 99
Hello All,
I have a pretty nasty Userform that is filled with textboxes. To be specific, there are 10 Groups as column headers (Group 1, Group 2, etc.) and 71 inputs as row headers (1, 2, 3 ,etc). There is a textbox for every one of these entries. However, if you can imagine, it seems like a pretty daunting Userform for any user to look at and attempt to fill out.
I was wondering if anyone had any bight ideas about how to make this more user friendly. Whether it involves how the user can view them (perhaps tabs) or how the user can populate them (maybe a button for each row). I don't know, and it seems pretty hard to find information on the web about VBA applications and making them user friendly. So I figured I'd just make a thread to get opinions.![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I have a pretty nasty Userform that is filled with textboxes. To be specific, there are 10 Groups as column headers (Group 1, Group 2, etc.) and 71 inputs as row headers (1, 2, 3 ,etc). There is a textbox for every one of these entries. However, if you can imagine, it seems like a pretty daunting Userform for any user to look at and attempt to fill out.
I was wondering if anyone had any bight ideas about how to make this more user friendly. Whether it involves how the user can view them (perhaps tabs) or how the user can populate them (maybe a button for each row). I don't know, and it seems pretty hard to find information on the web about VBA applications and making them user friendly. So I figured I'd just make a thread to get opinions.