#1   Report Post  
Posted to microsoft.public.excel.misc
UB UB is offline
external usenet poster
 
Posts: 120
Default Listbox selection

Hi
I have 4 sets of data that contain names of 4 different team members.
What I want to do is that when user selects TEAM A in the first list box the
2nd list box that has names of the team memebsr should show the names of the
TEAM A
The TEAM data is in cells
TEAM A A2:A16
TEAM B B2:B16
TEAM C C2: C16
TEAM D D2 to D16

Please advise how to write a VBA code and also where should this code be
Reply
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
Listbox Selection Displays the Column. Scott Halper Excel Worksheet Functions 3 February 3rd 07 10:36 AM
Listbox Selection Displays the Column. Scott Halper Excel Worksheet Functions 0 February 1st 07 08:50 PM
Listbox Selection Displays the Column. Scott Halper Excel Worksheet Functions 0 February 1st 07 08:50 PM
protect cells after listbox selection JLatham Excel Discussion (Misc queries) 0 November 30th 06 03:00 PM
Listbox & Selection sparx Excel Discussion (Misc queries) 0 July 31st 06 10:48 PM


All times are GMT +1. The time now is 06:52 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"