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

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.

--
Regards,

OssieMac


"Brett" wrote:

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

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

"OssieMac" wrote:

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.

--
Regards,

OssieMac


"Brett" wrote:

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

THIS POST IS NO LONGER REQUIRED.

"Brett" wrote:

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

"OssieMac" wrote:

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.

--
Regards,

OssieMac


"Brett" wrote:

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