specify worksheet in rowsource within a listbox

I have moved activex buttons to another sheet, and everything works fine, except the button for 'archiving clients'

when i click the button to archive it doesn't list the name of clients. i'm assuming this is because i've moved the command buttons (and therefore code) to a sheet other than the one where the list is.

i see rowsource is naming a range, but it's not specifying which sheet that range is from, its no longer the active worksheet.

i've attached the spreadsheet because it's difficult to explain the problem.

sorry, what do you mean exactly by create a dynamic range?

thanks

ok i sorted it, thanks it works well