Darren,

Thanks for your response. I had the same experience that you had, except I
am using Excel 2003 with SP2.

The user forms that I previously created had no problem, except this time.
Of course, I was not involved in combo boxes on the previous ones.

Thanks.

"Darren Hill" wrote:

Just on the off-chance this applies to you:

I got that Path/File access error a lot when using Excel 2007 (usually
shortly before a crash), and it stopped happening once I applied Service
Pack 1.


Please Help wrote:
Hi JLGWhiz,

Thanks for you response. As you instructed, below is my current settings:

ColumnCount = 1
BoundColumn = 0
ControlSource = B2
ColumnWidth = 60
RowSource = B:B

When I ran the user form, I got an error "Path/file access error". When I
clicked OK on that, I got another error "Run-time error 75: Could not find
the specified object.", and when I clicked "Debug", it pointed me to the code
"frmStudentNoLookup.Show".

Basically, I have two user forms: a main form and a lookup form. The code
"frmStudentNoLookup.Show" is located in the command button code on the main
form to call up the lookup form. The combo box that I need help with is
located on the lookup form.

As I previously stated in the previous post, if I include a cell reference
in the ControlSource, I would get the above errors. If I do not include a
cell ref, the control box would be blank.

Do you know what caused it to happen?

Please help.

Thanks.

"JLGWhiz" wrote:

Set column count property to 1, bound column to 0.
Control Source requires a cell reference e.g. "a1".
The Control Source displays the value of the item
selected in the combobox. Make sure your column
widths property is set to a number greater than 0,
probably 30 or 40 will be enough. If you are entering
the row source directly into the properties window, don't
use quotation marks. If you are using code to assign the
properties, DO use quotation marks.

"Please Help" wrote:

Hello all,

I have a sheet with student information. Of the student information, Column
B is Student No. How can I have the student numbers listed in my combo box
of my user form.

I tried having "B:B" in the RowSource event of combo box, and I saw the
student numbers in the design mode. When I ran the user form, I didn't see
anything.

Then I tried having "B" in the ControlSource event and "B:B" in the
RowSource event of combox box, and, again, I saw them in the design mode.
When I ran the user form, I got an error "Path/file access error". The rest
of events was unchanged.

Please help.

Thanks.