User forms

[iken]

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

 

[smcadman]

I have used this add-in to help with forms. Go here and download "Enhanced Data Forms 2":

http://j-walk.com/ss/dataform/index.htm

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

 

[Mutt]

Setting up extensive user forms can be very tedious! I have found more efficient to set up user input and output sheets and then protect the two sheets so that only the input cells can be modified - also use data validation tool to limit responses. The other actual working sheets are hidden and the whole workbook protected to stop them being accessed. In my opinion, userforms are of more use for drop down menus etc when defining user functions for users to access.

 

[iken]

Smcadman, thanks for link. I will give this a try.

Mutt, I realise this will be tedious, but worthwhile in the long run.

iken

 

[Mutt]

Go well with the userforms - if you should get stuck on some point wanna pose your question here under this thread and lets see if I can help - I have set up user forms often and sorted out several of their 'bad habits' - sure Microsoft have quite a few more we could try to work thru!