| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform w/ Multiple listboxes that link
Hello,
I am now about to experiment into the wonderful world o Userforms....and I'm nervous. Currently, I have the validation set up on 2 columns that link. Th first column is Department and the second column only shows Position available in what was selected in Department. I use VLOOK to accomplis this (=INDIRECT(VLOOKUP(F4,DeptLookUp,2,0))....F4=Depar tmen selected... I have the first listbox with RowSource = Department (which is the nam of the array that holds all the departments). How do I link this to th second listbox and only populate and list the Positions for tha Department? Is this possible? Thanks a bunch -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform w/ Multiple listboxes that link
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to create multiple listboxes in same collumn? | Excel Discussion (Misc queries) | |||
| Multiple listboxes to update pivot table? | Excel Discussion (Misc queries) | |||
| Userform w/ Multiple listboxes that link | Excel Programming | |||
| how do I link Textboxes in a userform to a Cell in a Worksheet? | Excel Programming | |||
| Userform and reading multiple listboxes | Excel Programming | |||
![miker1999[_13_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
