AndreTor
New Member
- Joined
- Nov 24, 2022
- Messages
- 1
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
As the title suggests,
I ran into this issue. I'm referring to this code posted on this thread: ComboBox Scroll with Mouse wheel
More specifically, the error occurs when I select a value via the drop-down list inside the Combo Box, then delete it and exit it.
It returns "Invalid property value", Run-time error '-2147467259 (80004005)', Unspecified error
If I try to debug it, it leads me to Line 121, Col 1 of Jaafar's code (ComboBox.SetFocus)
If you can't solve this, I'd like an alternative similar to the following:
Setting MatchRequired = False, and then coding that if you type a value not present in the list of said Combo Box and then exit the ComboBox it, it returns a string of my choice (i.e. "Please enter a value from the list").
Thanks.
I ran into this issue. I'm referring to this code posted on this thread: ComboBox Scroll with Mouse wheel
More specifically, the error occurs when I select a value via the drop-down list inside the Combo Box, then delete it and exit it.
It returns "Invalid property value", Run-time error '-2147467259 (80004005)', Unspecified error
If I try to debug it, it leads me to Line 121, Col 1 of Jaafar's code (ComboBox.SetFocus)
If you can't solve this, I'd like an alternative similar to the following:
Setting MatchRequired = False, and then coding that if you type a value not present in the list of said Combo Box and then exit the ComboBox it, it returns a string of my choice (i.e. "Please enter a value from the list").
Thanks.