×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

User forms

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

RE: User forms

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

RE: User forms

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.

RE: User forms

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

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

iken

RE: User forms

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!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources