Is there a way to have a list box in a userform to auto update it's list when a cell has change. This userform is activated when the sheet is opened. And it's vbModeless.