User form - Can't set ControlSource property. Invalid property value.

[Aland2929]

I have a range name called MonthChosen but if I type this name in the in the Control Source property section of my UserForm3, I get the following error message: [Can't set ControlSource property. Invalid property value]? I have another UserForm1 in the same workbook that uses MonthChosen without a problem. There is no problem with the spelling.
Thanks in advance

[JosephP]

do you have the correct workbook active when typing in the name?

[Aland2929]

Thanks for your reply. Yes, I have only one workbook open.

[JosephP]

can you post the file-after removing all data?

[Norie]

Why are you using ControlSource?

You could write a few lines of code to transfer data to/from a worksheet.

That would give you more control over what's happening.

[Aland2929]

Thanks for your reply Norie. I have tried to use code but receive an error message on line 5? Can you assist me with this?

Please Login or Register  to view this content.

Thanks in advance

[JosephP]

controlsource is a string

Please Login or Register  to view this content.

I agree with Norie though-better not to use controlsource at all

[Aland2929]

I still get an error message using this code on the following line: UserForm3.ListBox1.ControlSource = "Month_Chosen". The error message is:
Could not set the ControlSource property. Invalid property value. Run-time error: 380

[Norie]

I wasn't suggesting using code to set the ControlSource.

What I'm suggesting is using code to read/write between the userform/worksheet.

[Aland2929]

Can you explain how I would do that? I am trying to select an item from listbox1 on userform3 and have that selection placed in a cell that is named Month_Chosen?

[Norie]

That could be as simple as this.

Please Login or Register  to view this content.

That code could go in the listbox's Change or Click event, or elsewhere in the userform code.

[Aland2929]

Thank you very much.