User forms
User forms
(OP)
Has anyone mastered the user forms in excel (these are in the VBA area under insert).
What I would like to do is create a user form instead of having engineering spreedsheets (less chance of people playing with cells they shouldn't).
This would involve once the workbook is opened, the user from is displayed and not the workbook. (All sheets hidden and protected).
If there is anyone that can assist, or that may have a simple thing set up that can be used as a base for such, this would be greatly appreciated.
Many thanks
iken
What I would like to do is create a user form instead of having engineering spreedsheets (less chance of people playing with cells they shouldn't).
This would involve once the workbook is opened, the user from is displayed and not the workbook. (All sheets hidden and protected).
If there is anyone that can assist, or that may have a simple thing set up that can be used as a base for such, this would be greatly appreciated.
Many thanks
iken





RE: User forms
It is free, and somewhat easy to use. Read the "features", "how to use it", etc. on that site. Download the self-install, go to Data > Enhanced Data Form.
Basically, label the top row, click a cell in that row, then go to edform. Simple as that. On a different worksheet you can list items and name the range, for example "product", and then on your main page if your label matches the range name (product), it will give you a drop down list in your form. As far as security, someone else can chime in here....
Flores
RE: User forms
RE: User forms
Mutt, I realise this will be tedious, but worthwhile in the long run.
iken
RE: User forms