Could not set the RowSource property. Invalid property value

[Denny57]

I have tried to add a range into a combobox both by using VBA code and control properties but cannot get the details to be accepted.

When I add a range (eg Sheet1!M3:M11) in the control properties (Row Source) I get the abovre error message

When I try to add the code using VBA in the initialize macro, the User Form will not open and an error is reported at the module level, which from experience means that there is a generic error in the code. As soon as I remove the code, the user form opens.

Sample Codes which stop the user from from opening

Dim listdetails as Variant
'listdetails = Range("Sheet2!M3:M11")
'cbo1.List = listdetails
ALSO
Dim listdetails as Variant
'listdetails = Range("Sheet2!M3:M11")
'cbo1.RowSource= listdetails

Any help would be appreciated

 

[Micron]

Well, in absence of what needs to be seen but still isn't, I wish you luck but I'm going to withdraw.