Another little ? on CommandBars("Cell")

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi
Is there any way one can have a right click menu that scrolls right to another option (similar to the "Format - Columns - Width" on the menubar) rather than the "..." leading to a dialog box? If so could you insert what code I need into
With .Controls.Add(msoControlButton
.Caption = "DOWN on tick
.OnAction = "Amend_BidAsk_Tick_DOWN
End Wit
ie. the user right clicks, scrolls to 'DOWN on tick' which then scrolls right to give 2-3 new options..
Again, huge thanks in advance. Rgds. Brownie
 
Provided sample code in response to your previous post.

--
Regards,
Tom Ogilvy

Brownie said:
hi,
Is there any way one can have a right click menu that scrolls right to
Click to expand...
another option (similar to the "Format - Columns - Width" on the menubar)
rather than the "..." leading to a dialog box? If so could you insert what
code I need into:
With .Controls.Add(msoControlButton)
.Caption = "DOWN on tick"
.OnAction = "Amend_BidAsk_Tick_DOWN"
End With
ie. the user right clicks, scrolls to 'DOWN on tick' which then scrolls
Click to expand...
right to give 2-3 new options...
 
Back
Top