I have ListBox on a UserForm that pre-loads items from a list ("TheList") and then pre-loads the already selected items on that list from another list ("TheListSelected"). It works perfectly except for one little thing. I would like to relocate the TheList to another sheet but the code uses CELL and OFFSET and I don't know how to get them to read from a range on another sheet.
I've attached the file, but the code I ned to change is pasted below in bold:
Is this just a small tweak of code?