Populate List or Combo box based on User ID

S

Steve

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!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incorporating the User Profile location into a document template path 1
Link a text box based on drop down box with four options MS Word 365 0
Auto populate value from one task to another in MS PROJECT 0
Dealing with the error: unable to filter on excel hc home school 0
Creating a Search using a combo box and then creating a report. 4
Combo or list box 0
Highlight multiple items in listbox based on textbox item 1
Populate a table based on check box status 2

Top