Problems with opening userform with button on worksheet

[Jonno1]

HI, I'm having problems opening a userform assigned to a button/rectangle on the worksheet. The error code is 'Run time error 380 - could not set the row source property - invalid property value'. When debugging the script, the yellow marker refers to the macro assigned to open the userform - the section highlighted is 'frmsales.show'. I've checked all the names, properties of the userform etc to see if they match up and they do. Any thoughts?

[BadlySpelledBuoy]

The issue is actually further past that. Keep pressing F8 and it will tab into and step through the form code and highlight which one is the issue there.

Not much more I can suggest without seeing the file.

BSB

[Jonno1]

Hi, thanks for this, I've done this, the part of the code causing the issue is to fill the combo boxes on frmsales with options.
cbo_customisable.RowSource = "customisable"
cbo_customisable.ListIndex = 0
where customisable matches the named range in the excel spreadsheet.
The spreadsheet is enclosed, open with the password Woofit11 (nothing personal in it ).
The problem is opening the userform on the sales spreadsheet.
I hope this helps,
regards,
Jonathan

[BadlySpelledBuoy]

Press "Ctrl + F3" to bring up the range name manager and look at the one called "customisable".
The "Scope" of this named range is restricted to one sheet only, rather than Workbook.

Simple enough to fix:

1) Unlock the workbook (take the password off)
2) Press Ctrl + F3
3) Delete the offending named range
4) Recreate it, ensuring the "Scope" is set to "Workbook"
5) Try the userform again and see if it works.

Please Login or Register  to view this content.

Happy Friday.

BSB

PS. A little research into "Dynamic Named Ranges" might be a good idea. It will be half an hour well spent and you'll not look back.