Which Worksheet is Active?

[Bishop]

If I'm working in VBE and I need to know what the active Workbook is or which
Worksheet is active, how do I figure that out? Is there some tool that will
tell me this?

 

[ker_01]

msgbox activeworkbook.name
msgbox activesheet.name
(or, activeworkbook.activesheet.name)

HTH,
Keith

 

[FSt1]

hi
Sub whatisit()
Dim awbn As String
Dim awsn As String
awbn = ActiveWorkbook.Name
awsn = ActiveSheet.Name
MsgBox awbn
MsgBox awsn
End Sub

regards
FSt1

 

[Bishop]

This is perfect. How do I add a shortcut key to this? Say I wanted to use
ctrl+q to run this?

 

[FSt1]

hi
install the macro in a standard module then on the menu bar....
Tools>macro>macros
highlight the macro then click the options button. add your shortcut then ok
out.

Regards
FSt1