Command Button on form is activating sheet but not cell

Hi guys

I have a problem with my user form / sheet.

Ive created a work book that has 7 sheets, one of the sheets is called HOME the other one is BULKADD, I have a form that loads on the home sheet and when you click on a button called bulk on the form its meant to open the sheet called "BULKADD" and activate cell A2, when I do this every seems to be working but as soon as i start typing the text disappears and its actually being stored on the home sheet.

here is the code:

Private Sub CommandButton6_Click()

Application.Goto Worksheets("BULKADD").Range("A2")

Unload Me

End Sub

Thanks in advance

Gema

Hi there

Thanks for the reply, unfortunately ive already tried the string and it doesn't work either, the worksheet is coming up as requested, but when I start typing it looks like its typing into the BULKADD sheet but disappears once i hit enter or tab and appears on the HOME page.

I've never come across it before and im stumped.