Populate List or Combo box based on User ID
Hello all. I have a piece of code that captured the user's Windows
login id by using environ("UserName"). I have a block of Data in Sheet1. In column A, I have a list of User ID's. In column B, I have a Sale # that I would like populated in the list or combo box. So, if I login, the value in the environ("UserName") variable is "Steve". I would like vba to scan column A for Steve, and when it finds it, populate the list box with the value in Col B, noting that there may be multiple instances of "Steve" in Col A. So therefore they may be more than one item populated in the list box. Can this be done?? Thanks!! |
All times are GMT +1. The time now is 06:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com