View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cmpcwil2[_13_] cmpcwil2[_13_] is offline
external usenet poster
 
Posts: 1
Default Passing a comboBox to a sub


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