Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi!
I'm an Access programmer that has been asked to do a small project in Excel and could use some assistance. We have a spreadsheet containing "speeds" that are cross-referenced by column headings of "material" and row headings of "size". They are wanting to use a form with 2 combo boxes to select "material" and "size" and then display the "speed". Only the form should be visible to prevent tampering with the data behind it. Could do this with a form and query in Access in about 60 seconds, but I've never worked with Excel forms and controls. It must be Excel so that it can be distributed to remote staff that can't connect to our DB and who don't have Access. Have tried using manual entries into cells with combinations of VLookup and HLookup, but can't get results needed. Can someone point me to a resource (sample code, tutorial, etc.) that will show me how to accomplish this? Thanks, Bruce |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
Combo Box Values Not Sticking & Mult/ Combo Boxes in a WorkSheet | Excel Programming | |||
Creating a formula to find a range for a cross-referenced value | Excel Worksheet Functions | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
How can I return a cross referenced cell value? | Excel Worksheet Functions |