View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 576
Default Generic ComboBox change event

Tom,

You were so gracious in giving me generic code to identify and activate
Contol Tool Comboboxes on a sheet. (works a treat!)

Now could I get your indulgence for generic code to capture any of the
Comboboxes change.

What I would like is something like for any combobox, on change, the
next cell is selected.
Sub ComboBox_change
target.offset(1,0).select
end sub

You have already saved me a ton of code and I am greedy...

thanks...
--
sb