×
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

Toggle for Manual Entry?

Toggle for Manual Entry?

Toggle for Manual Entry?

(OP)
Is there a way to have a toggle button or drop-down list of some kind that would allow either manual entry or a lookup value? I have never used VBA, so excel formulas would definately make me happier, but I don't know that it can be done.

Basically, say I wanted to create a spreadsheet for simply supported beam deflection. I would like to be able to choose from a list that I could create of standard wide-flange beams OR choose "custom". If a standard beam is choosen, then the properties, such as cross-sectional area, moment of inertia, etc could be pulled from a table on a different sheet. If "custom" was choosen, these values would be manually entered.

I can do this now if I have the lookup function for finding the value, but then if I choose custom I have to type over the formula. Then, if I want to use the spreadsheet later for standard beams my lookup formula is gone. Of course, I could have the "custom" values in different cells and just use them if the ones for standard values are blank... Just wondering if there was a good way to do this...

-- MechEng2005

RE: Toggle for Manual Entry?

Some more explanation - It is a simple lookup based on the "type" selected in cell b2.  Lookup filles in cells b3 and b4 which would presumably be used for calcuation input.

Custom is simply another choice.  The values in the lookup table for custom are filled from a separate area at the top of the input/output sheet.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

RE: Toggle for Manual Entry?

(OP)
Thanks! That is exactly the type of thing I was looking for, I just couldn't think of the solution.

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