LISTROWS problem in userform

[Brett]

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

 

[OssieMac]

Hi Brett,

Check that RowSource contains the Named range.

Open Define name and check that the workbook contains a Defined name as used
for the RowSource.

 

[Brett]

Hi again Ossie, yes I had already done that and everything is as it should
be. There must be another reason for this. Brett

 

[Brett]

THIS POST IS NO LONGER REQUIRED.

Hi again Ossie, yes I had already done that and everything is as it should
be. There must be another reason for this. Brett