View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
natanz[_2_] natanz[_2_] is offline
external usenet poster
 
Posts: 40
Default right click menu, userform show

i have written a little code to add some new items to the "cells" right
click menu. the only way i could figure out to use a right click menu
was to call a second sub that opens the userform. here's what i am
doing now:

With Application.CommandBars("Cell").Controls
With .Add(temporary:=True)
.Caption = "Respond"
.OnAction = "module1.ShowForm"
.Tag = cControlTag
End With