If you are using a rowsource then insert into the appropriate place:Me.ListBox1.RowSource = "=Used_Locations"' Obviously change Used_Locations to you named range