View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MVM MVM is offline
external usenet poster
 
Posts: 53
Default positioning the control on a popup commandbar

I have a commandbar of popup type with a combobox control..
code is as follows/
Set myPopup = CommandBars.Add(Name:="MyBar", Position:=msoBarPopup)
'msoBarFloating) ' ', MenuBar:=True, temporary:=True)
Set myMnu = myPopup.Controls.Add(Type:=msoControlComboBox,
temporary:=False)

Question: popupbar appears as a bar next to curser. It has the combobox
control. But its position is not that good. combobox arrow is on far right.
It opensto the right of the control when the arrow is clicked. How to
control this position?
I like to have the drop down box to fall from the control similar to a combo
box

thank you
MVM