Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I created a user form with a list box. I use the
following codes to fill the list sub main() Dim Mon_List As ListBox ' LstB_Months is the name of the Listbox on the form ' *** Get a "Run-time error 13. Type Mismatch" in the ' Set Mon_List statement below. - Why ??? Set Mon_List = UF_Generate_Report.LstB_Months Call Fill_Mon_List(UF_Generate_Report.LstB_Months) end sub ' A simple test routine sub Fill_Mon_List(MonList as ListBox) MonList.AddItem "Jan" MonList.AddItem "Mar" MonList.AddItem "May" end sub I'm getting "Run-time error 13. Type mismatch" error when I try to run this code. Can someone please tell me what I did wrong here ? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
Compare List and Show Mismatched | Excel Worksheet Functions | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming |