ExcelBanter - Roesource problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Roesource problem (https://www.excelbanter.com/excel-programming/328067-roesource-problem.html)

Patrick Simonds

Roesource problem

I have a worksheet named:

Work Shifts Drivers

I want to create a userform with a ComboBox, but when I try entering Work
Shifts Drivers!A6:B6 in the RowSource block, I get:

Could not set RowSource property. Invalid property value.

What am I missing?

Patrick Simonds

Roesource problem

Solved the problem:

instead of Shifts Shifts Drivers!A6:B6
Should have been 'Shifts Shifts Drivers'!A6:B6
"Patrick Simonds" wrote in message
...
I have a worksheet named:

Work Shifts Drivers

I want to create a userform with a ComboBox, but when I try entering
Work Shifts Drivers!A6:B6 in the RowSource block, I get:

Could not set RowSource property. Invalid property value.

What am I missing?

All times are GMT +1. The time now is 03:26 AM.