Hi everybody,
I have the following code which is implemented on 35 comboboxes in on
sheet .. I wrote the same code 35 times .. only changing the comboxbo
number.
Can I implement the same code on 35 comboboxes without repeating it 3
times?
Code
-------------------
Private Sub ComboBox1_Change()
On Error GoTo X
ComboBox1 = Application.WorksheetFunction.Match(ComboBox1, [D2:D6], 0)
Exit Sub
X:
If Err = 1004 Then
Me.Activate
Else
Resume
End If
End Su
-------------------
I hope that my question is clear for all,
Thank you
--
LoveCandl
-----------------------------------------------------------------------
LoveCandle's Profile:
http://www.excelforum.com/member.php...fo&userid=2861
View this thread:
http://www.excelforum.com/showthread.php?threadid=56420