PC Review


Reply
 
 
bliddy
Guest
Posts: n/a
 
      17th May 2011
I am trying make a second combo box on sheet1 that will read anything
from a cell that matches sheet2.
Example: college football on sheet2 a1:a500 = teams b1:b500 = players.
on sheet1 combo box1 listfillrange=sheet2!$a$1:$a$500 linked cell is
a3 on sheet1. Trying to make a second combo box that states whatever
is placed sheet1 cell a3 that the 2nd box only reads the players that
match the team name. can this be done like listfillrange=vlookup(($a$3,
(sheet2!,$b$1:$b$500,2,false))
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2007 - Combo Boxes to break down list in othe combo box A_Barnes General Software 1 23rd Jul 2011 03:05 PM
combo box selection runs query to sum values in table not gettingparameter from combo box RCGUA Microsoft Access Form Coding 2 23rd Jul 2009 01:32 AM
Open form based on combo box value w/error message for blank combo box Ruth Microsoft Access 0 20th Apr 2007 11:00 PM
Two combo combo boxes on form to select specific report =?Utf-8?B?Q2h1Y2tX?= Microsoft Access Forms 1 12th Sep 2005 10:25 PM
"Combo Box - getting control combo box to stick in place in worksh =?Utf-8?B?YWpy?= Microsoft Excel Misc 0 15th Feb 2005 07:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:51 PM.