ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multi Select List box in columns (https://www.excelbanter.com/excel-programming/363423-multi-select-list-box-columns.html)

Kirk P.

Multi Select List box in columns
 
I'm new to Excel VBA, and I believe what I need here requires it. Here's my
data...

Col. A Col. B Col. C
Name GL Func Cd GL Prod Cd
AADELVAND,STEFFANEE A 1000 150, 151, 152
AADLAND,MARY E 1000 151
ABBOTT,JAMES A 1100 200, 201
ABEL,MARILYN S 1200 220

I need to send an Excel list above so people can identify a specific GL Func
Cd and GL Prod Cd for each employee. I would like the Excel list to have a
list box in each cell in Column B, and a multi-select list box in Column C
(employees could be assigned to multiple products). Making your selections
of Function and Product will record the selections for the associated
employee. Help?


lexcel

Multi Select List box in columns
 

I don't really understand what you want to accomplish, but you might
find the solution he http://www.contextures.com/xlDataVal02.html
This article is worth reading anyway.

Good luck.



All times are GMT +1. The time now is 01:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com