View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 113
Default Counting in a userform

I have 10 combo boxes in a userform frame. I would like
the user to select just ONE combo box. If any more than 2
are select, and before my ActiveCell.Offset updates the
spreadsheet. I would like to catch this multiple input
error and send msgbox then Cancel=true back to the
userform for correction.

My 10 combo's are as follows:
cboA.Value
..
..
cboJ.Value
I thought that I could loop and count, if count great than
1, stop and message, return and correct. My code locked me
up. Thanks.