Yes use rowsource to dicate the choice of locations available, but I need to know from what I have posted above, will it select the correct sheet as indicated by the value selected in the combobox?

Once I get past this point, I will be trying to build up a write to a section on the selected sheet.

Am I on the right track if I simply remove the line/s which are

[vba]
Sheet ("SheetName").Activate
[\vba]

I don't need another command button