Formula looking at Drop-Down list doesn't update my Shape

[monkeyharris]

Hi all,
Not sure if this is a glitch but i have a drop down list that looks at postcodes (range A2:B2993). I have another cell that looks up the drop down list it it updates perfectly. For instance, if the user selects AB1 in the drop down (V61), the cell looking up the dropdown (V57) will show AB (column B below) All Good. V57 then highlights a shape based on the postcode. My problem is, the only way the shape updates is if i double click in V57 and press enter????? Is this fixable?

Snake Postcode Map.xlsm
	N	O	P	Q	R	S	T	U	V	W
57							Enter Postcode		CT
58
59
60
61	Enter First Half of Delivery Postcode								CT20
62
63	Delivery Frequency by Postcode and clostest IDS Depot
64	Post District		Branch			MON	TUE	WED	THU	FRI
65	CT20		Chatham			NO	YES	NO	YES	NO
General Tariff

Cell Formulas
Range	Formula
V57	V57	=VLOOKUP(V61,'Postcode Districts'!$A$2:$C$2993,2)
N65	N65	=V61
P65	P65	=IFERROR(VLOOKUP(N65,'[MP Moran - Postcode matrix.xlsx]Postcode Districts'!$A$1:$C$3000,3,FALSE),"N/A")
S65	S65	=IFERROR(VLOOKUP($N65,'Postcode Districts'!$A$2:$I$3000,4,FALSE),"N/A")
T65	T65	=IFERROR(VLOOKUP($N65,'Postcode Districts'!$A$2:$I$3000,5,FALSE),"N/A")
U65	U65	=IFERROR(VLOOKUP($N65,'Postcode Districts'!$A$2:$I$3000,6,FALSE),"N/A")
V65	V65	=IFERROR(VLOOKUP($N65,'Postcode Districts'!$A$2:$I$3000,7,FALSE),"N/A")
W65	W65	=IFERROR(VLOOKUP($N65,'Postcode Districts'!$A$2:$I$3000,8,FALSE),"N/A")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
P65,S65:W65	Cell Value	contains "N/A"	text	NO
S65:W65	Cell Value	contains "No"	text	NO
S65:W65	Cell Value	="Yes"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
V61:W61	List	=$AI$1:$AI$2992

Snake Postcode Map.xlsm
	A	B	C	D	E	F	G	H	I
1	Postcode District	Postcode	Branch	Monday	Tuesday	Wednesday	Thursday	Friday	Comments
2	AB1	AB	Rosyth	YES	NO	YES	NO	YES	N/A
3	AB10	AB	Rosyth	YES	NO	YES	NO	YES	N/A
4	AB11	AB	Rosyth	YES	NO	YES	NO	YES	N/A
5	AB12	AB	Rosyth	YES	NO	YES	NO	YES	N/A
6	AB13	AB	Rosyth	YES	NO	YES	NO	YES	N/A
7	AB14	AB	Rosyth	YES	NO	YES	NO	YES	N/A
8	AB15	AB	Rosyth	YES	NO	YES	NO	YES	N/A
9	AB16	AB	Rosyth	YES	NO	YES	NO	YES	N/A
10	AB2	AB	Rosyth	YES	NO	YES	NO	YES	N/A
11	AB21	AB	Rosyth	YES	NO	YES	NO	YES	N/A
12	AB22	AB	Rosyth	YES	NO	YES	NO	YES	N/A
13	AB23	AB	Rosyth	YES	NO	YES	NO	YES	N/A
14	AB24	AB	Rosyth	YES	NO	YES	NO	YES	N/A
15	AB25	AB	Rosyth	YES	NO	YES	NO	YES	N/A
16	AB3	AB	Rosyth	YES	NO	YES	NO	YES	N/A
17	AB30	AB	Rosyth	YES	NO	YES	NO	YES	N/A
18	AB31	AB	Rosyth	YES	NO	YES	NO	YES	N/A
19	AB32	AB	Rosyth	YES	NO	YES	NO	YES	N/A
20	AB33	AB	Rosyth	NO	YES	NO	NO	NO	CHECK WITH ROSYTH BEFORE BOOKING
21	AB34	AB	Rosyth	NO	YES	NO	NO	NO	CHECK WITH ROSYTH BEFORE BOOKING
22	AB35	AB	Rosyth	NO	YES	NO	NO	NO	CHECK WITH ROSYTH BEFORE BOOKING
23	AB36	AB	Rosyth	NO	YES	NO	NO	NO	CHECK WITH ROSYTH BEFORE BOOKING
24	AB37	AB	Rosyth	NO	YES	NO	NO	NO	N/A
25	AB38	AB	Rosyth	NO	YES	NO	NO	NO	N/A
26	AB39	AB	Rosyth	YES	NO	YES	NO	YES	N/A
27	AB4	AB	Rosyth	YES	NO	YES	NO	YES	N/A
28	AB41	AB	Rosyth	YES	NO	YES	NO	YES	N/A
29	AB42	AB	Rosyth	YES	NO	YES	NO	YES	N/A
30	AB43	AB	Rosyth	YES	NO	YES	NO	NO	N/A
31	AB44	AB	Rosyth	NO	YES	NO	NO	NO	N/A
32	AB45	AB	Rosyth	NO	YES	NO	NO	NO	N/A
33	AB5	AB	Rosyth	YES	NO	YES	NO	YES	N/A
34	AB51	AB	Rosyth	YES	NO	YES	NO	YES	N/A
35	AB52	AB	Rosyth	NO	YES	NO	NO	NO	N/A
36	AB53	AB	Rosyth	NO	YES	NO	NO	NO	N/A
37	AB54	AB	Rosyth	NO	YES	NO	NO	NO	N/A
38	AB55	AB	Rosyth	NO	YES	NO	NO	NO	N/A
39	AB56	AB	Rosyth	NO	YES	NO	NO	NO	N/A
40	AB9	AB	Rosyth	YES	NO	YES	NO	YES	N/A
41	AB99	AB	Rosyth	YES	NO	YES	NO	YES	N/A
42	AL1	AL	Nuneaton	NO	YES	NO	YES	NO	N/A
43	AL10	AL	Nuneaton	NO	YES	NO	YES	NO	N/A
44	AL2	AL	Nuneaton	NO	YES	NO	YES	NO	N/A
45	AL3	AL	Nuneaton	NO	YES	NO	YES	NO	N/A
46	AL4	AL	Nuneaton	NO	YES	NO	YES	NO	N/A
47	AL5	AL	Nuneaton	NO	YES	NO	YES	NO	N/A
48	AL6	AL	Nuneaton	NO	YES	NO	YES	NO	N/A
49	AL7	AL	Nuneaton	NO	YES	NO	YES	NO	N/A
Postcode Districts

 

[Engberg]

Do you highlight the shape with a VBA macro? In that case, could you post it?

 

[Snakehips]

@Engberg I know from responding to another* @monkeyharris post that the shape updating was originally to be triggered by change to input to cell V57.

Subsequently they have changed the input cell to V61 with the expectation that the recalculation of the formula in V57 would still trigger the original change event code.
Neither of which will happen.
I have subsequently posted revised code to suit. Hence this question is now somewhat redundant.