Developed user form like GUI using only excel native controls (Without form or form based control or OCX/ActiveX control) to enhance the portability of macro based worksheet.
i) Programmatically hide/visible worksheet (Code driven)
ii) Storing data in separate sheet like a table in database.
iii) Add/Edit/Delete data through user form like GUI using only excel native controls (Without form or form based control or OCX/ActiveX control)
iV) Validation on Add/Edit with simple easy to understand error/validation message.