Hello Everyone,
So I've started delving into the world of custom user-forms.
If I take the time to customize a user-form (which I have) can I easily replicate that form and its cell references?
Hypothetical to help explain my question:
Say I have a user-form with 4 text boxes and two drop-downs. Each of those 6 fields corresponds to cells A1:A6. The macro to load the user-form is tied to a button sitting in cell A7. If I want multiple rows to each have a buttom that launches a user-form to populate that row's values, can I easily replicate the references and UF projects themselves?
Do I need another macro to replicate it for me? I'm testing using UF's in a personal sheet, but I'd like to incorporate them into a spreadsheet for my company. Problem is, that sheet will need 20-30 UFs, each UF having multiple fields which will reference cells. I really don't want to manually update all those references (plus, the more I do manually, the bigger the chance I'll make a mistake somewhere that I probably won't catch before it would roll out).
If you all need more details or more explanation, please let me know. If you could tell me if this is even possible (maybe a way to update/change all range references for everything within a UF), I'd be happy with that. Would love to learn about this before I try to do everything the long and difficult way. And if anyone has some basic macro code I could customize to this effect, I'd be eternally greatful!
Thanks everyone!
-LM
Bookmarks