How to determine active sheet

[JohnSearcy]

Hi -

I'm trying to remember, but it has been awhile. I have several sheets in a workbook and a comand button on each sheet that calls up the same userform. The information entered onto this userform needs to be entered onto the open or active sheet a person is in at the time. I can't remember the correct way to do that - what I'm getting at is....If Sheets("sheet1") is active Then..... else if sheets("sheet2") is active Then.....and so on. Hope I explained well.

Appreciate any suggestions,
John

 

[VoG]

Try like this

ActiveSheet.Range("A1").Value = TextBox1.Value

 

[Rick Rothstein]

Your question is not entirely clear, but it sounds like you want to use the ActiveSheet object which holds a reference to which ever worksheet is active. For example...

MsgBox "The currently active sheet is named """ & ActiveSheet.Name & """."

 

[JohnSearcy]

To VoG: I never thought about that. That would work. I guess I was overthinking it.

To Rick: I was overthinking it and I guess nothing llike what I was thinking exists. Both of your suggestions are what I was looking for.

Thanks to you both!!