Thread: retract dropdown for combobox
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
  
Posts: 9,101
Default retract dropdown for combobox

See VBA help

ShowDropButtonWhen Property

fmShowDropButtonWhenNever 0 Do not show the drop-down button under
anycircumstances.
fmShowDropButtonWhenFocus 1 Show the drop-down button when the control has
the focus.
fmShowDropButtonWhenAlways 2 Always show the drop-down button.


"joeeng" wrote:

Is there a way to programmatically retract the dropdown list for a combobox
on a form?
Reply With QuoteReply With Quote