View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pjbur2005 via OfficeKB.com pjbur2005 via OfficeKB.com is offline
external usenet poster
 
Posts: 19
Default active control box name on worksheet

Hi

i have tried to find the answer to this,

I ahve used a control box command button and want to determine its name from
code so i can use this elsewhere. i know application.caller does not work

Private Sub ToggleMonth1_Click()
Dim CtrlName As String
With Worksheets("DP + SDS")
ctrlname = ? 'help it should be toggleMonth1

End With


End Sub

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/201006/1