Thread: Command Bar
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DEFJ DEFJ is offline
external usenet poster
 
Posts: 13
Default Command Bar

Is there a way to set a command bar's "OnAction" property
to place the commandbar's caption in a cell?

I need a hint.
What I'm trying to do is make a right-click button that
lists choices for a user to place in the target cell. The
amount of choices will vary. I've got the commandbar
code down but was wondering if there was a way to call a
macro that looks at the caption of the selected control.