Thanks RoyUK,
With a little tweeking, the code does exactly what I needed. The only other thing that I was wondering about is if I would be able to fill a column with the selected names also. I have tried all kinds of variations to the code below and have been able to fill the cells with both names and numbers, but they are always the same i.e. the cells A105:A125 are always the same no matter if I can get it to give me a value or a name. Here is the full sub
For some reason I am unable to highlight the line that I want to be noticed, but it is in the middle there and is
With this line, it will fill the range with the name of the last person selected in the listbox. I am sure that I am doing something wrong with the first part of the line, since it is filling everything the same, but I have tried variations of it includeing .coulmns and also with Cells, but with no luck. If I can not easily fix this, I will start a new thread, but I believe that it should be simple
Bookmarks