Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating Lists in forms
Hello all, I have a list which I can get to appear in a list box. What I want to do is then show a list of 6 items which are unique to the item selected in the first box. Every item in the first box has its own set of unique values Any ideas?? Thanks Mark -- marksince1984 ------------------------------------------------------------------------ marksince1984's Profile: http://www.excelforum.com/member.php...o&userid=33484 View this thread: http://www.excelforum.com/showthread...hreadid=549238 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating Lists in forms
With no other details, maybe this will inspire you.
Private Sub Listbox1_Click() Dim cell as Range Dim secondList as Range set secondList = Worksheets("Sheet2").Range("A1").CurrentRegion ' remove headers set secondList = secondList.offset(1,0).Resize(Secondlist.Rows.coun t-1,1) Listbox2.Clear for each cell in secondlist if cell.Value = Listbox1.Value then Listbox2.AddItem cell.Offset(0,1) end if Next End sub -- Regards, Tom Ogilvy "marksince1984" wrote in message news:marksince1984.2909za_1149639601.5537@excelfor um-nospam.com... Hello all, I have a list which I can get to appear in a list box. What I want to do is then show a list of 6 items which are unique to the item selected in the first box. Every item in the first box has its own set of unique values Any ideas?? Thanks Mark -- marksince1984 ------------------------------------------------------------------------ marksince1984's Profile: http://www.excelforum.com/member.php...o&userid=33484 View this thread: http://www.excelforum.com/showthread...hreadid=549238 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dropdown lists and populating new table based on the selection | Excel Discussion (Misc queries) | |||
drop down lists and forms | Excel Worksheet Functions | |||
Populating Drop-Down lists | Excel Worksheet Functions | |||
Populating Specific Lists Based on Criteria | Excel Programming |