Select sheet from form

[Hatye]

Hi,

I have a user form that are supposed to open a worksheet. I use

Private Sub CommandButton2_Click()

Sheets("Rapport_Linjer").Select


Me.Hide


End Sub

to open the proper sheet, but changes made in this sheet are made in the sheet where the form was opened, although I'm currently seeing correct sheet (selected from the user form).

Do I also need to activate the selected sheet, or is there any thing else I need to think of?

 

[steve the fish]

That piece of code will select the sheet in question then hide the userform. There is nothing there that makes any changes to any sheets.

 

[Hatye]

Hi steve the fish,

I'm sorry if I was unclear. I want the macro above (which is assigned to an button in an user form) to select/show the proper worksheet (which works).
When the macro is done, the selected sheet is shown, and I then want to make all necessary changes manually in the sheet.

The problem is that I can see the selected sheet after the macro was run, but the changes I do in this sheet isn't done in the one I see. If I go back to the sheet I run the user form from, I can see that all changes are done in that sheet.

 

[steve the fish]

Sorry no idea what you mean. Once you have run that macro the sheet you will see will be sheet named 'Rapport_Linjer'. You can type happily in that sheet. It wont transfer that to another sheet unless you have more code elsewhere telling it to do that.