Solved: Can a form have data referred to another sheet

[Aussiebear]

If a form was designed to enter and save data to say Sheet 1, and you changed the active sheet from Sheet 1 to Sheet 2, could you still use the term Me.txtbox.text (which you were using when Sheet 1 was the active sheet) or do you need to use the forms name as well?

[mdmackillop]

The form is independent of the sheets. You need to be more careful in using sheet variables though as an unqualified Range("A1") etc. will default to the active sheet

[Aussiebear]

Thanks MD