I have added a list box to a user form. The row source is a range name called MonthList which contains a list of 12 months formatted as mmm-yy. I have a range name called MonthChosen but when I attempt to type this name in the control source, I receive the following message: Could not set the Control source property - Invalid propert value?
Thanks in advance
to what does MonthChosen refer?
Josie
if at first you don't succeed try doing it the way your wife told you to
MonthChosen is a range name that stores the month that is selected from MonthList.
to what range does it refer specifically. there is no reason that what you describe should not work unless you defined a multiple cell range or typed the name in the controlsource box incorrectly
personally I would use code to populate the listbox and the range rather than using the rowsource or controlsource properties
It refers to a single cell. The name is typed in correctly?
can you post the workbook then? (remove any data)
Thanks for your interest Joseph but I have decided to use Data Validation[list] to solve the problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks