Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
empty listbox giving error
i got a userform with a list box. the listbox gather data from sheet6 colum
c. it works perfect if i got data in c1 to c8. the userform.show property and the listbox etc works perfect if i got data in the cells i never needed to have all the cells in colum c empty. now i saw that if i do empty colum c i am gettin a runtime error on the list box ================================================== ============= run-time error '381': could not set the list property. invalid property array index. ================================================== ============= im calling the userform in workbook open event. if a cell on sheet2 is empty then the userform prompt the user to select names from the list box. the error points to this line if i select debug... ================================================== ============= If IsEmpty(Sheets("sheet2").Range("d42")) Then UserForm1.Show ================================================== ============= let me know if i need to provide the code behind the userform thanx Phillip |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
empty listbox giving error
i rechecked it now. if i have data in c1 and c2 i dont get the error
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Any idea why this is giving me a #Value! Error? | Excel Worksheet Functions | |||
Giving me a error ( =REF! ) | Excel Worksheet Functions | |||
Function giving error | Excel Discussion (Misc queries) | |||
Function giving Error | Excel Worksheet Functions | |||
Pivot table giving an error | Excel Programming |