LISTROWS problem in userform
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
|