Luis Diaz
asked on
Excel VBA: add-in & userform & maintenance & update approach
Hello experts,
I have attached my add-in used on a daily basis.
I am trying to move most of the procedures that use inputbox to userform as recommended at the following questions: :
Question 29175323
https://www.experts-exchan ge.com/que stions/291 74861
I need some assistance and feedback concerning the following topic.
How to manage the various userform that will be reported in the add-in in order to ensure a proper maintenance..
The primary approach is the following:
-Use the userform names as the procedure related + bottons:
-Report the procedure related to each procedure in each sheet. (Column M of attach file)
-Set up a new column with conditional format if len >32 as userform cannot have more than 32 (Column L of attach file)
-Make compatible those userform reported on the link above with the requirements above.
If you have other better approach or other requirements to add, please do not hesitate to propse.
Thank you for your help.
LD-add-in.xlsm
I have attached my add-in used on a daily basis.
I am trying to move most of the procedures that use inputbox to userform as recommended at the following questions: :
Question 29175323
https://www.experts-exchan
I need some assistance and feedback concerning the following topic.
How to manage the various userform that will be reported in the add-in in order to ensure a proper maintenance..
The primary approach is the following:
-Use the userform names as the procedure related + bottons:
-Report the procedure related to each procedure in each sheet. (Column M of attach file)
-Set up a new column with conditional format if len >32 as userform cannot have more than 32 (Column L of attach file)
-Make compatible those userform reported on the link above with the requirements above.
If you have other better approach or other requirements to add, please do not hesitate to propse.
Thank you for your help.
LD-add-in.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Bill, I test the procedure and it works! Thank you very much for your help.
ASKER
I will take the time to test it today and tomorrow and let you!
Regards,
Luis.