'Run Time Error '380': Could not set the value property. Invalid value property'

[Peter Thompson]

Hello,

I am currently developing a user form and am getting a very strange error message.

When it goes to retrieve data it gives me the message 'Run Time Error '380': Could not set the value property. Invalid value property'. When i hit the debug the following peiece of code is causing the issue:

'lst4Complexity = lngComplexity'

I cant understand what the problem could be as lngComplexity, in this instance, has a value of 5 and lst4Complexity is a listbox with options 1 to 5.

Has anyone had similar issues? Or can anyone suggest a solution?

 

[Norie]

Peter

A simple MATCH function is used to obtain the row of the complexity value in the range that populates the control.

That is 1-based, the 1st complexity value is in row 1, the 2nd is in row 2 and so on.

The items in the listbox have a 0-based index, the 1st item has index 0, the 2nd has index 1 and so on.

To select the item in the listbox we need it's index, so we subtract 1 from the row.

Hope that makes sense, if it doesn't post back - I'm not too good at explaining these things.

 

[GazzaLDN]

Norje,

Thanks for the suggestion. Ive tried it and it works. I was wondering if you could give an explanation as to how it works.

For example when I retrieve one record the value of complecity for that record is 5, which the code populates in the listbox, but I dont understand how it does this as when I step through the code lngindex = 5 and the -1 then takes it down to 4.

Thanks,

Peter

I had a similar issue with a userform that had worked fine for years and then started throwing up this error message. The dropdown list was populated with dates, the list range on the worksheet had been reformatted to show the year in four digits rather than two. Once reformatted all was well again.