glennjrobertson1980
New Member
- Joined
- Mar 30, 2015
- Messages
- 12
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.....
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.....