rowsource field in properties

[glennjrobertson1980]

Hi,

Hope somebody can help me. I am using Excel 2007.

I am creating a userform, the only object on this userform is a combo box. When i click on the combo box in the properties within VBA I have RowSource i am completing this as I normally would with - 'sheet1'!B11:B16
when i click on the drop down for the combo box it shows the source data as it should.

I then have a macro on my spreadsheet that when clicked shows the userform.

However when the form loads there is no information in the combo box and when I go back into VBA and click on the combo box and look in properties the RowSource field has totally disappeared...

Please can somebody help.....

 

[glennjrobertson1980]

No nothing is missing I have the same in Excel 2007 as my version of 2003.

I have tried closing excel 2007 and starting again but get the same issues.

 

[Norie]

Do you have exactly the same references in 2007 that you do in 2003, including version?