ham123
04-02-2019, 01:57 AM
Greetings experts,
I am currently trying to make an excel sheet into a form and I am in need of a manual which contains instructions which can teach me (but not limited to):
- How to create drop down boxes and create the selection based on my own input instead of a range
- How to create drop down boxes and create the selection based on an external database
- How to format cells into checkboxes with requirements (example: can only select 2 out of 4)
- How to limit cell characters
- How to lock certain cells and inputs such that it is locked until you meet previous cell requirements
- How to permanently lock certain cells and rangers
- How to create an upload button and embed the file as an object into a cell
I am trying to avoid using VBA or Userforms as no one can maintain a Userform; I need it to be as sustainable as possible after I leave.
Any help is much appreciated! https://www.excelforum.com/images/smilies/smile.gif
I am currently trying to make an excel sheet into a form and I am in need of a manual which contains instructions which can teach me (but not limited to):
- How to create drop down boxes and create the selection based on my own input instead of a range
- How to create drop down boxes and create the selection based on an external database
- How to format cells into checkboxes with requirements (example: can only select 2 out of 4)
- How to limit cell characters
- How to lock certain cells and inputs such that it is locked until you meet previous cell requirements
- How to permanently lock certain cells and rangers
- How to create an upload button and embed the file as an object into a cell
I am trying to avoid using VBA or Userforms as no one can maintain a Userform; I need it to be as sustainable as possible after I leave.
Any help is much appreciated! https://www.excelforum.com/images/smilies/smile.gif