View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tracktraining tracktraining is offline
external usenet poster
 
Posts: 68
Default assign action to custom button

Hi All,

I have created a button via customize - toolbars- new - added command
button (rename from &button to &Report)

I would like to know how to refer to this button in vba coding? I would like
to code: when the button report is click, then load the userform Report_Graph.


Private Sub Report_Click()
Report_Graphs.Show vbModeless
End Sub

i think this code would be in the ThisWorkBook object.

Private sub
or is there a better way to do this?

thanks for the help.

still learning,
tracktraining
--
Learning