MixedUpExcel
Board Regular
- Joined
- Apr 7, 2015
- Messages
- 222
- Office Version
- 365
- Platform
- Windows
Hi,
Thanks to AlphaFrog on this thread of mine:
http://www.mrexcel.com/forum/excel-...ombo-box-using-visual-basic-applications.html
I have the Drop Down List (Combo Box) on Sheet 1 and my list of items for the Drop Down List on Sheet 2.
I have a cell, say Sheet2!C1, which is the cell linked to the Combo Box (I have named the cell as a range for this to work)
I have a vlookup which is triggered by the result which is in Sheet2!C1 but whenever I clear out the Search Field, Sheet2!C1 is also blank.
This results in the vlookup resulting in #N/A.
I have rows unhiding / hiding based on this result.
My Question:
Is it possible to type into the Blank Field of the Combo Box and the linked cell Sheet2!C1 to only show a change of value when an item from the list is selected in the Drop Down Combo Box?
OR
Is there a piece of code I could put into the Sheet that would stop the cell Sheet2!C1 from changing until it matches an item from the list
OR
Can you make a Vlookup or Index Match formula only change it's result if there is an Exact Match to an item on the list (not like putting true or false in the formula) but if the answer from the formula doesn't match an item on the list - it doesn't change?
Thank in advance for anyone who can post possible solutions.
Simon
Thanks to AlphaFrog on this thread of mine:
http://www.mrexcel.com/forum/excel-...ombo-box-using-visual-basic-applications.html
I have the Drop Down List (Combo Box) on Sheet 1 and my list of items for the Drop Down List on Sheet 2.
I have a cell, say Sheet2!C1, which is the cell linked to the Combo Box (I have named the cell as a range for this to work)
I have a vlookup which is triggered by the result which is in Sheet2!C1 but whenever I clear out the Search Field, Sheet2!C1 is also blank.
This results in the vlookup resulting in #N/A.
I have rows unhiding / hiding based on this result.
My Question:
Is it possible to type into the Blank Field of the Combo Box and the linked cell Sheet2!C1 to only show a change of value when an item from the list is selected in the Drop Down Combo Box?
OR
Is there a piece of code I could put into the Sheet that would stop the cell Sheet2!C1 from changing until it matches an item from the list
OR
Can you make a Vlookup or Index Match formula only change it's result if there is an Exact Match to an item on the list (not like putting true or false in the formula) but if the answer from the formula doesn't match an item on the list - it doesn't change?
Thank in advance for anyone who can post possible solutions.
Simon