I am trying to pass a comboBox to a sub to carry out sort on the items,
but I am having difficulty in doing this using the following...
Sub BubbleSortCombo(ByRef myCombo As MSForms.ComboBox)
Then call the sub()
BubbleSortCombo("ComboBox 1")
returns a type mismatch error I know it is to do with the different
type of control but can't figure it out. I am using a ComboBox from the
VB toolbox.
Can anyone help?
--
cmpcwil2
------------------------------------------------------------------------
cmpcwil2's Profile:
http://www.excelforum.com/member.php...o&userid=33411
View this thread:
http://www.excelforum.com/showthread...hreadid=536793