Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
LISTROWS problem in userform
Hi there, I have a combobox on a userform that has 11 listrows, hideselection
= false, maxlength 100 and rowsource is a named range. It is for use with a workbook called "1. FINANCE surname" where surname varies. If I open up the master Finance book and load the userform I can see all 11 dropdown rows (but at this stage they don't have any data). However, during a "run" it will only ever show one dropdown row, which is blank (and I know that there is data available). At that point I have used the immediate window, and all the settings (listrow etc) mentioned above are as they should be. What can cause this please? Brett |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 07 vs. 03 "listrows" reference <subscript out of range | Excel Programming | |||
Combo Box ListRows property; changing programmatically | Excel Programming | |||
UserForm Problem | Excel Programming | |||
Userform from a Userform Problem | Excel Programming | |||
listrows property | Excel Programming |