View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carpie Carpie is offline
external usenet poster
 
Posts: 5
Default Macro to clear combo box values

I have 16 combo boxes (ComboGame1 - ComboGame16) which allows the user to
pick between two NFL teams. My trouble is that the only way I can get them
back to blank is to go into each one individually and clear the values. I've
tried with no success to record a macro of doing this but in the end that is
what I want. A button "Clear Winners" that once pushed, will set the value
of each of those 16 combo boxes to null. Can you help?