I have an Excel user form with two combo boxes ('Task' and 'Status'):
> I tried to set the Style property of both combo boxes to 2 - fmStyleDropDownList
to restrict the user to only selecting entries from the dropdown box and not being able to place their cursor in the field and remove or enter text.
> The 'Status' combo box appears to work without generating an error message
> The 'Task' combo box now gives me the following error message when I go to select an item from the dropdown menu:
Run-time error '380'
Could not set the Text property. Invalid property value.
When I click on Debug, it points me to a highlighted line:
.Text = .List(.ListIndex, 1)
As I am not very savvy in this area, I have attached the Excel file with the user form in question to demonstrate what is happening.
Please let me know if you need any more information.