View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
R Ormerod R Ormerod is offline
external usenet poster
 
Posts: 37
Default Combo box problem

I have the following VBA set up for a range of combo boxes in a worksheet:

Private Sub ComboBox15_Change()

Range("C121").Select

End Sub

When trying to save the file I intermittently get the 'Select method of
Range class failed' message and the debug command takes me to the VBA for one
of my combo boxes, as above.

The only way round this I have so far found is to delete the code relating
to the affected box, but I would rather not have to do this.

--
R Ormerod