LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Show cross-referenced value from 2 combo boxes

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting Combo boxes to change options based on other Combo boxes. Ancient Wolf New Users to Excel 1 March 27th 09 06:29 PM
Combo Box Values Not Sticking & Mult/ Combo Boxes in a WorkSheet questor Excel Programming 0 September 15th 08 01:38 AM
Creating a formula to find a range for a cross-referenced value Fay Roberts Excel Worksheet Functions 1 February 22nd 08 04:12 PM
Selecting subsets using combo boxes or list boxes CLamar Excel Discussion (Misc queries) 0 June 1st 06 07:43 PM
How can I return a cross referenced cell value? JR Excel Worksheet Functions 5 August 15th 05 11:37 PM


All times are GMT +1. The time now is 03:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"