Hi there,

I've built a userform that contains a listbox with the names of teams that people will get requests from. But I have also put a textbox in the userform so that people filling the form out can add a new team (if they are not already in the list). There may be times when both the listbox and textbox will have values. I was wondering if there was an if statement I could use that would allow for information selected in the listbox and information entered in the textbox to populate the same cell. I am able to populate said cell with the items from the listbox and textbox when either one is used on its own, but not when they are used at the same time.

Any help would be appreciated.

Thanks.