| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
| use selected value from one combobox to populate another combobox | Excel Programming | |||
| ComboBox list reliant on the entry from a different ComboBox | Excel Programming | |||
| How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
| Populating combobox from another combobox | Excel Programming | |||
![cmpcwil2[_13_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
