Det enklaste är att strunda i VBA och använda dataverifiering istället
Markera A1:A2 och gå till
Data->Dataverifiering->inställningar
Tillåt: Lista
Källa: antingen ett område med värden, eller en lista med värden
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAXwAAAEwCAYAAAC0fcrdAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAABhaVRYdFNuaXBNZXRhZGF0YQAAAAAAeyJjbGlwUG9pbnRzIjpbeyJ4IjowLCJ5IjowfSx7IngiOjM4MCwieSI6MH0seyJ4IjozODAsInkiOjMwMn0seyJ4IjowLCJ5IjozMDJ9XX1aMdVBAAA40ElEQVR4Xu3dCXwU5f0/8E/uAzkVUJFfrQQMhGhRixHUeNYgClQsbdWf2B/1ihqUiv3zs1j7owUtihoFz2jV1ioVS1AgalHjQYM3RwAh1AMPLrnJnex/vjPPZGc3u5vZe5P5vH2tzPPMM8/MTna/88wzs/MkHThwwAUiIuryktW/RETUxTHgExE5BAM+EZFDMOATETkEAz4RkUMw4BMROQRvyyQixzl48CCWL1+u/yuOOuoonHPOOUhPT9fTieTFF1/E6NNPx1FHHqlyPH23bRvee/ddXHrppSrHP78B//nnn0dtba1KAdnZ2fjFL36hUvG3ceNGrFy5EmPGjNH/WB988AHWrl2LPn36ICsrC3V1dZgwYYIq3THv+oio6/ruu++wTQuUeXl5+r8rVqzAyJEj9XSikYBe+dZbKDzrrHZBP9A8XwIG/MLCwrbg984772Dz5s0dBkQJnPIKJthGgvf2EhHZVV5ejv/6r//CiBEjVE5i8RXYgw32wnYf/hlnnIHBgwdjzZo1KiexyNkIgz0RBau6uhq7d+/GD37wA5WTeCSgS2CXAC+BPpRgL2y38IW19W62+E3S8t+3b5/eLWLKz89H9+7d2+Udc8wxev/Z//zP/6hcYPHixRgwYAB+/OMf69PyBxBykJGDjbluUV9fr29bZWWl3s305JNP6vlCyptkORFsfeY86Rr65ptv9DLWMxvv+r7//vuYn9EQUfhqamr0WCYxIScnR+UmLjPQi2CDvQjqLp2ePXvqwVHIDpKALS8J4tLyz83NxahRo/R+dMmX4C15ZjkJmlu2bNEDpwR36XcX0p8m9Ur5V199VZ9nLiPBVOYLCbJSn/e1BCln/msGeVMo9QmZZ74P65mNfDiEtT4i6pxWrVql9913hmAfCUEFfGnBZ2ZmqhT0lrW85GJpINIilnLSqjfJ6ZPZepajrARlsWfPHr0+s24JvF9//bU+TwKwBOhghFqfzJMDkOjbt69+EVhIgLcuE+z2EFHiaGxs1L/rnYG1G8favROMoAL+l19+icMPP1yfluApLXZp5UoL3x+zq0bKSXmTBEpp1UtrWwK/tWVu1mu+zMAbqkjXJ2c6RNT5FRUV6d3Oic67z967T98u2wFfukaktWwNzGafttlSF9ZuH5O5Q6UlbyUHAjml6t27t8qBPh3JC8ORrk/69a31mdcBiKjzkVsyDxw4oFKJyTvYm0IJ+gEDvnTBmF0hwtrXLcHanCdB0GQeBCRf+uilnFy0lbT1vn4h/WbSxWK9On7BBRfoBxazbnmFI9r1mWc8RNT5fPrpp+0aoolGflTlHexNZtCXMnbwl7ZhkoOaHLTkQEBElMiC6sOn9sxf9xIRJTq28INkPsLBZN7XT0SU6BjwiYgcgl06REQOwYBPROQQDPhERA7BgE9E5BAM+EREDsGAT0TkEAz4REQOkbR3717eh09E5ABs4RMROQQDPhGRQzDgExE5BAM+EZFDMOATETkEAz4RkUN43JbZ3Nysj+LucvFOzXAlJSUhPT0dqampKoeIKL48Ar6MOSuDficns+EfrtbWVn3s2+zsbJVDRBRfHgH/0KFDOOKII1SKwrVr1y41RZ2ReZbW0NCgcihWeIYcHQz4USQBv0ePHipFnY10bR48eBDdu3dXORQr5r7nGXJkse+GyA9pZfJ6Vnxw30cHAz4RkUMw4BMROQQDPhGRQ4QQ8CtwQ8YN2v9DIcsW4sEtKikqbkDGDVptWx5EYeGDMGZZy/lYxqdwtouIqOuLfwu/aD4a5hcBg25CZeVNGKSyg1eE+Q3ztf93Jq+jpHuJ9v9gyXLnYsF/VNInO2UiLdA647HNsdoHsp7u+t085uvcgCuN1nYFqtfOOiO9XdF6nxSqMAO+an0/qLXSMzL0V6GlKb7lwUKVLy1vKTseT6AKtw4zy23Bg4XGct7L+hZofdYzgcDbZcw38x+0LOdve4z6brhBez9tZyFEViNx9+oDOHDAeK0oPk7lEyWOCLTwtQC+8WL9xykN5b9G1a3ztPAoKjDv1uEol3y95S0t8HL8GgW4Z30DKm+Stvwg3FQp8+VVjuFtywbib33e/JeruGE81t2zXp/3JF7UDkKmQNtThXW5T6IhrLOQQFRraEGJn1aizFctyJKXVZ74Dxac692ylLKX4Cm8j9+eaOb5KieM9ZaUnNuW/3qJKldiPfewrt9fvnW7hN15vs5xAm9v8PtJdLTOaOhoncb74f6nWIhAwNcC+DTVkVJ0sRbQ12Gz3gQejNyCJzBe+ucDkT58vUUtrX9z2UD8rc+bv3IVePmJAlx6oRG2B900Q5tn4Xd73MtEjxagtYOU3kp86Vd4/7f3a18Rw+sll6D67tXGvIuhBXPTcSheYbYsX0Kevsz5KNWmf6VanUZr01c50/uozn0cB1bfDe0IgZcv1spo0yOfetlj/XhJll2Nu6vvajtN979dHc/zVZ9b4O0Nfj/ZWWc4jIOrGQTNeGZvndz/FBtR7MM3Wsvrc+dowdPPxVQJrnNysV61qD0CbzzEfXu0AH3z+cbk+RdrAbsam/Uvxet4+amRmFikugn0eRavm60tadWby/jgt5yq+7jByNOmc+W4pk9b1699eS+RZU/Eb99/Hxv1A2Gg7eponq/6vATY3uD3k811hsyzS6dU3zy76+T+p9iI+kXbQTc9iXsKArTchw82ukgqXrZ0rUSTnHlU4cVlaoO81xvz7QmTfCnvysVq1RJzf8G82C3nl6+AFo4O6gt7e32J9HuwI1Lr5P6n8EUx4JsXRofh1uEzoHfZowgX/9py0Va6Wp4Yb3ShvIwYtai1M48n74G2Ee3XG5ftsWMQcke+j0UVqon1+ssep8rIG6ydgGu8873ZLdeO1/rbBNquIOb5E/T2RmCdERWpdfqrJ4j368j9T95CCPjW2x9lulIFc2FNy7S6ACq3XSpF840846Kttcx8r2U7mhahlNPILaBqvetz1+GJgkthdM9LuY62Jx6OQ/HjRv+ufoqtHYzaWlxy2vzUJe3zcT4u/pXloq3fcnZ4rb/tVtIA2xXMPF+3poa0vWGuM+IitU5/9QTxfh25/8mbI5+WKbeLDru1SqXkrqHoBHM+LbPz279/P/+GcSL7vlu3bipFkcDHI0cRA37nx4AfPwz4kRf1i7ZERJQYGPCJiByCXTpRxCEOiSiRMOATETkEu3SIiByCAZ+IyCEY8ImIHIIBn4jIIRjwiYgcggGfiMghGPCJiByCAZ+IyCEY8ImIHIIBn4jIIRjwiYgcIoSAX4HijEKU1qhUcQYyin0NUS7litXg5Z7L2GetIzT69mVkoNCycsmTTTb/jS7P9+C5PaG8v/D3CRE5UwgPT5OAMwe51ZUoqSlGxpJxaFjgHsLQN8syOSorJuK1Xn8SbXuIyEnC6NLRgtd4oLwt2EswK0RxcSEyCktRo9KlNfLveJShCtPzrC1tyTdau+4zBH91qNm2ljFJvnu97pa8pY52dfuqpwalhZblK7SDXNt8O9tjpL33g1HcnKcvqAmmPve80lJtm9Ry1jMZa32FpaWW5YjIiUJu4VcXABPLrC1VyR+P6rnVqNQzjXJGa9Y6rUoXZ2DJuAYsKJKAOgXQ6wpUh91lrHyvd06uKivBe04uqitLkNNu+91qSguRt3GGfiZjXT749+C9PZ7p0OrTDiJTyo2zLHk/chBuWAA5DFu3VX8P04G5ln1htXXrVjVFRJ3dwIED1ZSnEAO+tFSBAo/g6Bm82gcm73lGHaYp5RLoOqrDzjJWgerzTgeop6YURvy9EMu8AnHw7yHQvEjX52+epInIaULs0inQWorlWotxShhdBFJHAxoajFeHlwF0oSwTATkXYiIWYVnFMu3/E3FhW8CM9PbE6f0RkSOE0YdfhAXleZg+xdrfbVcOcguqsGhZMEuGsoy3IoybYqmjYgnKCqwB3J8cDMmrwsYlG4GJF2opIy/87bGKcn3yXo0pInKo8O7DL1qA8rzpyPO4yOmLEWjdF21zUFI2F1qGutho5zbDUJZpr2iBnJmoOsZXY26Z9N93rGjcFJSVVWvx3iwdme1xi3J9S4Apag4RORPHtHUI/aLtoonqAjUROVF4LXxKaBLkjbOFDOMOHZtnM0TUNbGFT0TkEGzhExE5BAM+EZFDMOATETkEAz4RkUMw4BMROQQDPhGRQzDgExE5RMIGfHm0r+fz6omIKBwJ+sOrGpRqkb6kBNq/Odq//H1opLRs2oSmDz5Ay7p1aPn2W6C2FsjORuoJJyD9gguQOny4KklEXU0UWvjy3HXj5/zul3WEJvOhYDLtNXJTW2s+B0M2jteWmwP3oyy9y5BdzdXVqH/mGeybOBF7i4pwaOZM1L/wApreeQdNH32k/1s3fz72jRuH2nvvVUsRUVcThYBfhAX689zLMaXt+e7moBsyzxiNqSNFC6zLUSgkkO8ZPRr7Lr4Yh+68E82ffKLm+CeBXw4CRNT1xLgP304rXYb3c58dGI9TluVkNCjLI5ZlOD/3QLXkQ+3cuWj97juVsq/prbfUFBF1JQl40TYHJZXmqE/y7Pp5WriXMwP3GYN7WEUKRebPf45uf/oTerz4InouW4bujzyi5hiaP/hATRFRV5KYd+lI611v4UurvhqbfJ0RFC0wBu4mv7KnTUNyv376K/NnP0O3u+5C7w8/RLc5c5D5y18i7aSTkJqbi6SsLLWEwVVfr6aIqCtJvIAvwX5OLqrbrgNQqNLOOgu9q6r0V7e770bmpElI7tNHzXVr/vhjNWVIO+00NUVEXUlitvDzhhgDdQQah5V9+BHTqB0QrFJPPllNEVFXkngBv2gcppTJLZkZXuOweo+LS5HQuns3mletUikDAz5R18QRrxyu4Z//xMHf/EaltGB/6qno+fe/qxQRdSUJ18I3b8f0flF0NDz3nJoyZIwbp6aIqKtJuIBv3I7Z/kWR1/TGG+1+ZJV+xhlqioi6msS8aEsxUb9woZoyZE6ejORjjlEpIupqGPAdqunDD9H42msqZciYOFFNEVFXFJWLtkte8QwklHgGP/cs+lW9p1LAzpN/jE2TO+evHsZd9BM1RUSBRC3gX3rJRSpFiaZpwwbsOv98lTL0ef55ZJx+ukrFxr59+/DNN9+gpaVF5diXkpKCAQMG4PUV79gO+L1vfBv1Ta1odbV95NtJTkpCeloK9j3EaxnU9TDgO9D+O+/EoSeeUCkgo7AQff72N5WKnfXr1+PYY49FZmamyrGvvr4eX3zxBdZv/I+tgN/rhkrUacHeruyMVOx5kEGfuhb24TtMy9atHsFeZP/3f6up2JKWfSjBXshywZwZNDT7b9X7UtfYrKaIug4GfIep++c/1ZQhbcQIZBZ1/YfQBerG8cV3cXlMtzmAT2fTFQYQsr6HrvB+Yo8B32Hqve7M6XbVVWqKJp8+QE0RdU0M+A7S/NlnaPr0U5UyZF5wgZpytr/8Ol/7f3BnAUYr0/gleGFpafvWZ6n5mG/v5z+5l/McqN9Yrri4EBmFpTCyLWXbHhboXc7XoEFWUt5rAKG2fHM5P9uh6qsoVuV8bYPfMh1tl8myHR71e+cF4q8O7/3pbDEK+MtxbdIo3O+xxyXvWu3//vhahsLR8PbbasqQNWECkg47TKWcY8JJ/dSUQYL9mxu/x9Pvfqty7KkoHo/qudX6L8HLsMjrya5acN04zvilePkUVOkD+RisyzWU52H6FGswqkJ1bhkaKkv0J8ZKWZTLr82rMbd6jiUoW8v5GjTIyvcAQra2o3outKMElozTymjTBWVLLHV3VKaj7TLIdpRNKTfKqTEu/L9v3+ztJ4pjC38MHnU9qv2fYqX+9dfVlCHj7LPVVPw1NTXpd934I/OkTCT0yk7DU78erk+HGuy1EIMlZQWYqAbZzymZ4TV2gxZcp6lrI/IE2LaBfDyX0+dVLcKytgBlmaeXBcrGS8tVC8hVVdjos5zGzqBBHmxuR84Q5GnTuVJMn7bWbaNMh9tlbEfbvtIFet++BLGfHC6OAd+zBV9z/ygkJSVpL2n1y7wL8Rj+jVsGJ2GUXqgG94+S+cbLyCO75DHIjStXqpQh48wz1VT8uVwulJaW4hMfA61LnsxrbbV/W2Ugf3n3G1Ru3IPP7zkzxGAfS0ar3GglN8DnIG+JOmhQWNtl4317CLa8MyVIH/5yzL0lH8u0L71Lb/VL638ZrsFpuG+zCytv1psOuHmlzJfXMuTfMldbiuxq3rxZTRnSCwqQ3LevSsVfeno6Zs2ahWeffdYj6Mu05Mk8aSlGigT9EXesDCPY5yC3oAqLzCZxoMF6PBjjOngsVzARvhuhXusIxM6gQR6C2Y4wdLhdvt5jEO9bF2x550qQgD8YQ097DBde20EIX36tauFL638tPuPf17bmTZvUlCEtL09NJY5u3bp5BH1rsJd54ZBf0HrbW+v/Xnsfxb3koKTM6LvWuyw8BusJrGiB9Ger5cZXY26Zv/5lr3X4uyXU76BBVu0HELK/HSGytV3Sz2/ZDv2Cq8333SbY8s4Vo1/aShfNLAzdvBJ6Y13XPk+6dQbrLX1p5XvNl2A/ayg2r7xZ+/P6qo8C2T9zJg499ZRKAT3vvhvZl1+uUvGxdu1a5Pk48MjncKa2vSJQsK+ursZnm7+09Uvb3je9g9oG+z+mykxNxr4FhSrVsZrSQuQtmohqXhykBJYgLXxDzs3P4L7TArTc8483vkzLF2stfApGkxZcrVIHD1ZTiUcC/OzZs/VXuC17kzwmITM1xWdL30rmZ8uzdHwEe6P1aLyEBHkznTcdkW8hE0VYDAO+cQFW75Jp13UjLXaZNxi35M9UrfYxmHCN5aLtmAm45rELjeUXA9foy5EtLS1o/PhjlTCk5uaqqcQkj04I9bEL/uxbcCbqHj0LDY+d7fcl8/fM930x27wgKC+RU1JpyauEutuRKGHx4WkO0PjRR/h+/HiV0oL9kCHo+8YbKhU//rp07AqmS4eIEqxLh6Kj5auv1JRB7tAhpbUVrqYmuOrr4Tp4EK4DB9C6dy9c33/f9pJbWiVPf+3fr5dpe+3ciZZNm9CknUE1r1qFpnfeQYvXHVFEiYItfAeQwLTz7LPRsm2bnj78pZeQPnKkPh1P0W7hN2vzW7/+Gq3ffouWb74xprWDX8uXX+pBHs3ReyKmDBWZfvrpyL7jDiRFuGuKKFQM+A4hrdNGrQWaMnAg0oYNU7nxFcmA3/rdd3qAb1m/Hk2rV+utbVdtrSoZP6mnnYaecRhrgMgXduk4RHKvXvqD0hIl2AsZtUoGMgmFLCfLJ7lcqL37buwZPRoHrrkGtfffj6Y330yIYC+a//1vHJo9W6WI4ostfIobGeJQWvnmXS/B0G+FbGzEzpl3oPuX/p/B05GmpBS0JCWjKTkVrUjS/21JTsFRfbKMAvJgfHmkg/zC23y0gzat39wp6aws/RfLSb17Iyk9Xe++aXrvPbR+/71e1NRHO+tI6t5dpYjiI2oBnyiaDvvqS5xw7116C9+flGOPReoppyB5wADc8sZ+fJ7aC99l9MHWrCPQkJyG1gD35Pfqlobt94U4xq92INh/2WVoev99lQH0ePZZpGlnIUTxFJWATxRth2bMQP0LL6iUIW3kSL3PPHXYMP0lgd6Ude1bQY16JceC+kdDf5rooT/8AfVPP61S2gHqnnuQccklKkUUH+zDp05HboX0DvZZN9yAHs8/j+ypU5F+/vkewV5EbojDDK8BOYxBNryf15585JFqytCq7pAy+F6mY9bl7NYh5aLxbJlQ34M/3u8t0DaHs+5Qlu1oe+zwfn+R3Hf2MeBTp9OwbJmaMkjLPvs3v1Gp0Nkb4rAABTYG5Eg+6ig1ZZC7iOJDBj9ZoP2/M0m0be6M+9A3BnzqdJrefVdNGdLHjVNToQtmiMOJMyZikcfoUFbSesvAT664QqUNLVs/0fP1Z+8UL1G5wmjtuYfh82792WkNqjI+h1S0Lh+onJD5Zr51yEbrc4O8WrrL3HW5T3z8DW1orL/jIQet2+y9bpnnPVyjd72ey7vr87WsnWEYveuzknlqeY+hFb3zEgMDPnU68kMqq7RTT1VT9oQ9xGFOCWbkTcc8H99lc6i9N9ctVTmGAx+tcQ8nqB2fPJ8NH4lh+PwPqejJ3tCLnkM2VmDe9Dztbckzg6wtXc+6ysabBwN55LGUlZf30IbBvlfvdfsertFevb6WDbStHYvE8IyxxIBPnU7L11+rKUNyP88A3pFIDHEoz5LHHO9WqnuovR5Dzld5hsxDqbi06DgjoQ95aBWJYfi0IOZzSEVv/sp5DnnoOWSjDDBShvHtWqsB1ul3aMNg36u/dXsLYx8GPTykKRLDM8ZWlAL+Ovzt1ltxq/X1t3VqXiCy3L1YsUMlibzoz7k5cECltA9wjx5B398emSEOizBt4iJMKfUcWEYPglrr8WB9PZIHDlR5huyd8erHD5fRCq7OnaMFMRsXLyM65GKQ6w5WVIaHND4DxllDYg23GMUW/lEYc9s9uOceed2GMdv+YjPoEwWgfYGskvr0UVPBCX+IQ6MVnDd9EarbnkXnNdReY6Pxr7LkbbWugMMQGnW0tQptD1kYLq9t97HenJIyzC2wtoDd5WtK53gOkRj0kIuBtV93IEHuw5C31Wuf6XzlJY4Yden0w7m/uQojPnlVtd53YMW97tb/vXqmtO7/gk/wHZb/2czzVU6K/o0HD6fy+rFU269fOxD5IQ5FERaU50E7a1fcQ+1lZ2Sgdft2lW/Yd+fpRtdBwOEQtTpmSH+4dAl0VDaS3Nvefr3mRcg8bfYMy3P/C5C3cYpe3mMAGFtDG9rla93th2v0FGgfei0b1rbK2Ue4wzPGVpR+eCXB+1UcedtvcG5b96oE7z9j2wX34HKj+1SRsqtx4j2XY7jP5UyWchLwV5+IezwrIgeQe/B3Wy7SSrdJ78pKlfKv/y3vYu+hJpXqWLf0FOx+yPdAKHa07tiBPZbHUCcffTR6e91dlMg4ZGPXFL+LthK09Za7tOq3Ybu/fntf5YZfzmDvUEny3JrsbJXSAuvWrWip6fj0WR6T0C091dYQh72yUn0Ge6PF5v9l5d26T+7fX00lLg7Z2PXFLuDvWItPvxuBEyVOSxB/9UjcpvfvX4URRon27JYjR0kr9Bxv9tCsWWgoL0fz2rVo+eILfRCSPaedhu+HDNGforlv/HjsnzwZX6Uuwq6jK7Fn2GrsO3sbDl6VgbrfD2k3xOH2B85QNXsyL8L5e1k1f/ihmjLIKGOJjkM2dn0xCvjr8Lc/LwfGnI+2dvmR/aH32qxbrbXcA/BVTg4E7MN3LHl0gpUE+IO33KIH9r3nnKMHd72F3dxsPCdfOxBImYYlS/Tn29SVluLQ7bdj/xVXYM8ZZ2D3iSdiz5ln6l0we0aMwO78fBy6805jkJQQNa1cqaYMqUH+VoAoGqLYhy9dMG4jrrL23Vvma1+wEZ9sa+u3X/e3W/EXbcZRY27Db87d4bvcDi3gsw/f0SQwt+7bp1LRkzp0KFK01nnKoEH683GSevVCUo8e+vgCyb17A5JOS1OlDXLr6J6TTlIpQ++339ZHwSKKJz4tkzolGaqw9r779K6ceEvu2VN/do5cX5C+ejm7kDMKU+qPfoSeL72kUkTxw4BPnZr02Te+8ooxfq20+GWg8T17jAFIojhmbTC6/fGPyLzsMpUiih8GfOqyXAcP6r/KlVfr/v1IamqCKy3N6ILx+rdFa5WbA5y3btmC5s8+Q8vmzaqm0KWPHYvuDz6oUkTxxYBP5Ierrg4tn3+OVu0goB8ItLMGl5xB7N4Nl/Zq3blTv9/e35mEDHiSfccd+uMfiBIBAz5RmOTswaUdDPQDwp49eoBP/uEPg36oG1G0RSXgc0xbiqVxF/1ETRFRIFEL+Oef6/vHK0Sm2tpa7JauEZvPw7FKTk5Gnz598N6/P2LAJ7KJAZ/i5uuvv8YPf/hDZGZmqhz76uvr8fnnn2PDZ58z4BPZFL9n6ZDjScs+lGAvZLlQzgyInIwBn4jIIRjwiYgcggGfiMghYhTwN+AfM2di5j82qLTbzsqHMHPmQ6jcqTJ8kuXNMtZpIiKyK7Yt/DXrtHBttRPr13oOFEHO1NTUhC+++EKl2pN5UoaIQhfDgN8fJ5ywHSusTfMNb2Ft/nk4QSUN6mzAzxmBp52ofEiV1V4PtdWtzgIq/+FjHiUil8uF0tJSfPKJ9aHaBsmTebwrhyg8MW3h9zvrXPRfu14L04YN67Yjf5jnz883/OM54LJZmDWrBOdtX9FB101fFN4oZeV1Gfr/6y3LGcR2/GvHcGPeZSdgu8c8SjTp6en63+rZZ5/1CPoyLXkyz3sYQSIKTowv2g7F8P7/wlsSeXdWYgXORWFfY45hA9atAdY8J63yUvxr+3bs2KVm+bPBbMU/hzVakN/RdoDoj/POGmpMDh2unUVY51Ei6tatm0fQtwZ7mUdE4YlxwNdi71nnYfu6Ddi5fi36D1cB2YMWqEvMVvss/MxXEZME+xX9UKKXvcyra4g6I2vQZ7AniqyYB3z0HYb87Svwwo58mA1wtyPQr/92rF0fRFO8fz/oJwkb1mktfOoKJMDPnj1bfzHYE0VO7AO+9Luf2x/oN8wI1B60eT8/D/hXqeqm+UfgfnfpqlnznFF2HdjC70Lk0QmhPnaBiHzjw9Mobr766ivk5eWpVPCqq6vx2eYv+fA0Ipvi0MInIqJ4YMAnInIIBnwiIodgwKe4kVGrZCCTUMhysjwR2ceLthQ3MsRhTU0NGhsbVY598svcnJwcDnFIFAQOYk6dHgM+kT1RCfhERJR42AlKROQQDPhERA7BgE9E5BAM+EREDsGAT0TkEFEK+BUozihEaY1KFWcgo7jCTBjTNaUoLCyFUcRa3nNZos6mdds2tG7ditavvoJr1y64QvidAVE0RL+FrwX48ShHw4IiI120wJjOKUFlZQlyjFyiTq3+iSew/8or8f1xx2HPqFHYU1iIPWedhd0jR2J3bq6e3j95Mg797neof/ZZuGpr1ZJEsRPlgK+11scD5Waw19rzpYVaaz/DeBV22Iz3U948SyBKAPt++lMcmj0bTe++q3LakxZ/0zvvoP6553Do97/H3tGjUffoo2jdu1eVIIq+qAb8RVPmILd6AcxwrzXrUVLZgIYGeZUjb/o87ZAQSLDliWKr/pln0Lx6tUrZ17pvH2rvvht7tbMBCfxEsRDFgF+FqqoqLFrm1YqX1rneYh+PMlRjU0eNfF/lzW4hojhrePFFNeWWcuyxSBkyBKm5uUg+5hiV65urvl4P/NIdFMqBgygYUQz4BZhbLa3yKe4LsBK85+SiWrXYp6hsv4ItTxRrlid2Jh1+OPqsWoVeb7yBXhUV6LlsGXq//TYOr6lB78pK9Hj+eXSbORPJ/furJdykO0i6huRaAFG0RLkPvwgLyvMwfYp5N44mb4hxobZiidZit8FXefbhU4LInj5db8XLq/v99yOpb/uRmuWgkDxwINJGjkTmr36F3lpw7/aHP+hnAt7kWsD+q65C87p1KococqIc8DVFC1CeNx15cgtm0ThMKRtvdNEsQcct9mDLE8VY2ujReiteXjJtS0oKMv/7v9GzvFw/AHhr0uraN24cGrT5RJHEp2USxVnja6/h0B//iNavv1Y5bt3mzEHmz3+uUkThiUrAlxa5L3K3DRG1J7dn1t1/v37Xj7fDtPwMrcVPFC628IkSSMMrr+BgSYlKufXU8lOHDVMpotBEvw+fiGzLuOgidH/sMZVyq3v4YTVFFDoGfKIEk37eeej+yCMqZWhcuhQNL7+sUkSh4Zi2RAlq8F+fRr/3/61SwN7cYagubt/dQ11DLMZmjlrAv/SSi1SKiELRXFODnWedpVKGI7W8pMxMlaJ4aWxsxNatW1FXV4eWlhaVG5yePXvi6KOPRnp6Ol586RUGfCKn23XhhWhas0algMNffBHpBQUqRfEgwX7Tpk16rJRXsuXX1na1trZi9+7d2LFjB4YMGaLHzFgEfPbhEyWw9JEj1ZSh6dNP1RTFy7fffov+/fujX79+IQV7IcvJweLwww/XzxRihQGfKIGl/ehHasrQ+NFHaoriZd++fejVq5c+LYE71JeQoC/dQrHCgE+UwNJOPFFNGZr4jJ2EkJKSoqZ8swb1QKSeUK8BhIIBnyiBpRx1lJoytO7eraYoUVkDvZ2gH0sJGPCX49qk0XjA+pz8mgcwOulabU64POtefm0SkpKM12iPFYbCWrdMR7Jucqqk9HQ1ZXDx8SQJzVeAT6Sgn4AB36oGD4zWgubkhSodQdpBZNMEF1wueS3D8Jsnex5kwjIGj+r1aq/N9wM3z43AwYocSYKFtfuguVlu8VAJSiSBAnuiBP2YbIUE7WvNiLf8WiSNfkAL5SqYB2wF52Dqe1rQfO93GK5ydFKHXqFRR0h150zF1DFqGoMxbJSajETd3kYN09ZAFJokr4cRuiToU8KSWy5N1ulEEJOAP3bSKDy22Iicyxc/hlGTxmqhXAXzthZ2KK3gnMjUvXwubsYkjNVHWjGFV3fNA6ONg8Jk4On3pmpLEYUmKS1NTSns1klIEtx9BXh/+fEQk4CfM3YSRq3bpLeON60bhUlmZJVWs95SvhCPYV3H49uaxjwK16NG8zzsuqXcH4dhsxmUI1R3ztT3jIPC08DkiFx/IMfyCvjyuSIKRWw6lnLGau3nhVi6fKn2f9WSNgOtailfY5QMXhh1663wxRPg8tcCj8R250zF7655DOpEgShoSd63ACZYNwF1HjG6kpCDIcNXYv3i9dCaye7gOlyNV7t8sdZSDlWIddc8gMnrf9fWmvctAtutreePj12DCYFWQxSId8BnH37CS6RuHKsYBXxgzIRr8Nhj69zdImMm4JrHLjS6RhYjuBa+tLL1C6iGUOquWboQK80y6qVfgI1A3XodZr2Db8bwZY+C8Z5C5h3w2aWTkOROnECvRNApH54m988vnuBCwMZ5iKJZN1Hd4sWoLy9Hy/ffI0kLAjKKVeYFFyCjsFCVaG/nGWeg+fPPVQro9+GHSDnySJWiWFu3bh2OP/54/Vey4QRyOQOQX9muX78em7ds5cPTfFuOxVHrIolm3eRo2pd7/x13YO+NN6L+9dfR9PHHaNQCd+0zz2D35Zdjz5QpaKquVoW9aGeKHmL4U3xqLysrC7t27dKnza6bUF5iz549+mOSY6UTBnz5UVO0ukiiWTc5WZ3Wqj/05JMq1V79q6/i+4svRv1yH1f3U1PVhKKCBcXHwIED8b12hiZBP9Tn4Mhy27dv1x+PLM/EjxU+D58oBvZOm4a6hfZ+Md7j9tvR7frrVQrYeeaZaP7Pf1QK6Pf++0iJYZCg9uSZ+J999pketEO5TTZVO4j36dMHQ4cO7RoDoBCR24g5/4fs775VKeDT225HSkM9Dl/zKY5+c4XKdftqzEXYqr3EyX+4HZlai9L0wZ/+jMbuPVSKuopOG/CJyNO+Sy5Bs2Xwku4PP4z0Cy7Qp+tfeAGHZszQp60OKy1FxkUXYU9BAVq1U39T748+QnLv3ipFZF8n7MMn6nzSzzlHTRma3n1XTQGZP/85evz1r0g+5hiVYzg4bRqa16/XCjepHEOSd58+kU0M+EQxkDrKfDqfoeHVV9WUIU2bf9h996mU0tyM2v/7P7gaG1WG4v1sHSKbGPCJYiDtpJM8WvCuXbvQvGqVShnSTj4Z3e66S6UMTe+/3+4Z+O0epkZkEwM+UYykn3++mjLUPtb+wRyZkyYh8+qrVUqxPkpBfujj/ctbIpsY8IliJP3009WUoenNN3HozjtVyq3bjBn6L3B9Sc3PV1NEwWPAJ4qRtLPP1i/QWtU/8wzqHn1UpdyybrlFTXnK+NnP1BRR8HhbJlEstbRg/+TJaFq5UmUYMq+4AulnnaX387ds3YqWjRtRe++9aq4hKTsbvd96C0n8jlKIGPCJYqxVC+j7fvlLtH7r/iGWXZm/+hW6zZypUkTBYZcOUYwlDxyIw7xa73bVP/WUxz38RMFgwCeKg7RTT9V/bJUyaJDK8S1lyBCkeV3srbv/fjVFFBx26RDFWdMHH6Dp7bfRVFmp9/EnH3ccUn7wA/1OnbTzztMfybD/F79QpQ3Zv/0tsq69VqWI7GHAJ+oEaufORd3DD6uUoecrr/i9fZPIF3bpEHUCWTfeiJRjj1UpQ11pqZoisocBn6gTSMrK0rtxrBpfe01/0iaRXQz4RJ2EPE7Z+4dbtbNno3XbNpUiCowBn6gTka4dae2bXAcOoO6hh1SKKDAGfKJOJHnAAGTffrtKGeqfew6Nr7+uUkT+MeATdTKZl12G9HPPVSmD3MXj8hoohcgbAz5RJ5RVUqKmDC01Naj38bhlIisGfKJOSB6TnD19ukoZ5GFrrvp6lSJqjwGfqJPKuv56pOTkqJSh6Y031BRRewz4RJ1Y1g03qCnty9yjh/7MfSJ/+GgFok5OxsZt+eYbpJ9xBpL69lW5RO0x4BMROQS7dIiIHIIBn4jIIRjwiYgcggGfiMghGPCJiByCAZ+IyCEY8ImIHIIBn4jIIRjwiYgcggGfiMghGPCJiByCAZ+IyCEY8ImIHIIBn4jIIRjwiYgcggGfiMghGPCJiByCAZ+IyCEY8ImIHIIBn4jIIRjwiYgcggGfiMghGPCJiBwiae/evS41jUOHDuGII45QKf+Ki4vhcrUtFtDDDz+spoiIKJ6CDvjXX389Tj31VPz0pz9FVlaWym1v9+7dWL58OT788EPMnz9f5ZJTVRRnYHxZAeZWV6IkR2USUUyF1KVTVFQUMNiLPn364JJLLkFra6vKIeeqwabccjQ0zACW1ag8Ioq1kAK+BHM7/B8UKlCcUYhSj+++Na/9fGkhZmRkoNCSKXnFFe5/g+drO6KsohgZsrE1pSgsLNVCYbACbbPMK9b+n2hyMGTjeO3vNwe4MJjmfeDPRPTFcp3xfq/+JNK22CHbG+p3wMd79fl9DeVvFc52RU4nuWhbgSV6d0ADKi39AUULGrCgyP1vp1C0AA2ysTklqKws0UJhJBVhQcMC7f+JR/5GDQ3szqFoi/B3IGLf18T4biZgwJcj4XiUoQrT86RFX+qRdrfkpZzR6s/wOMIaR9zi4kJk+GxBW5YrXqLyTNZ57mNxTalWl57vPkK3z6tBaaFaVntZz0Tc/JUxtrm0VGtN+Fze3zZ7v1dVj76o/TqNfWwuF3gbfe/X9uty775w9os/ibCv7W6ztT5zp/jKC8RfHYH/Hvo8bRnZNvMM2XN9/rbDmu/9HXGz/x2wsz12ytjZ50Y9xiw17edv7bn9UtYad6Sc3b+xKdD67G+XMd/Mt343w5eAAV+OhOWYArNFX+KRNlvyFcXjUT23Wms1ai3H8jxMn2L90FehOrcMDT6OyB7LjYP2B3aTeSiXlmi1tq45bX+cedPztGzJN4/QvvJyUFIpaXmVI2/6PK2Ut0BltA/axnHGvPIpqLLMC7TNgd6r3TrLsMhSZ+BttLuusvFmEAh3v/iSCPva3jZLfWVT5PqFVk59eH1/zvzzXz7w30OfVz0XWgTDknHa8tp0QdkSj/fqq97A+8AU7Heg4+3puEywnxPh72/tvf3ecUf2aCTX5y2U72b4OkmXjjeji2ei2R9cNA5TqhZZrgda5nnwsZwxpZF52od7vBxZtQNIVRU26vXlILegDOM9WkC+8jTS36cfmaWlUI1Nvr7IfstoH7Rp6mimb5c5L9A2C3/vVdirM6dkhmedAbYx+HVpwtovfiTCvu5wG4z62tal8/c58ydQ+cB/D31ezhDkadO5Ukyftr5XX/V2tA9MwX4HOtoeYaNMsJ8TrR7ff2s/2+8tYuvzZu8z2O67GaZOGvCjRfsjaEd344hunk0YR/nq3DnaH92z1eqRJx+MObmo1peVloIPdsrEW6S3MRr7JRH2dVj1+/qcBRJsebvCqTfE70A4Ilq/r++1l2i/nziIU8Avwrgp2inNPPdurimdg7KCiTZv4jCWX2Q26SuW2FxWjupeyxlTGq95XnJKyjC3wPNo3S4vb4hWi8ajXi92yngItM2h6qDOoLdRuOtr97eMxn5JhH3dYf2+PlOBP2ftBVveLn/1BrcPQvoOhCPC9fv6XnuI9vtpJ7j9H6yQAn5dXZ2aCkx+fOVP0QLpN5Rb9eR0KQN50p/W1hepDghtF0/aK1ogfWp5xvLjtbrKfPVjetOO6mVG/6C+3BJYjtpe89qO+uYFFO20N2+GusvER56clpWp9+NRr4WdMu0E2uZQBagzpG0UBcjbOEVfLm863H+PaOyXRNjXturX6qu0fE717gN/nzN/gi1vl7967e6DEL8D4Yho/b6+115xJ9rvxye7+z80Qf/S9oYbbsApp5yCMWPGBLwfXw4KL730ElatWoVHHnlE5VIikrsV8hZNRLXPi392yJdnDnL5K1qiiAr/u+kppGfpyOMV5Fk6SUlJKqc9c340nqUjRz5/pC+SOqZ/kKZXqZT05YYTrBnwiSIlst9NTyEFfCIi6nx4lw4RkUMw4BMROQQDPhGRQzDgExE5BAM+EZFDMOATETkEAz4RkUMw4BMROQQDPhGRQ7T7pS0REXVNHgE/JSVFTRERUVfjEfCJiEyubdvQ8uabaFmzBtixA666OrikF0D7N6lbNyQddRSSTzoJycOHI+VHPwIyM9WSlKgY8Imonab589G0YIFK2ZN6ySVIHT8eyaeconIo0TDgE5GHxltvRfPy5SoVvNSf/hSpl1+O5KFDVQ4lCgZ8ImrTuno16i+7TKXCk3bTTUi79lotyvgfN4NiiwGfiNq0/uc/qL/4YpXSAsSAAXrQTs7NRZL00cvgQ/JqbkbrmjV6/37rhx+idd06tYSnlNGjkf773+v1UPwx4BORh/qJE9G6caM+nXzCCcj8+9/16UBaP/oITU8/jZYVK1SOW9IxxyBj9mwkn3yyyqF44Q+viMhD2s03I6lvX/0unLQbb1S5gUkwzygtRcb8+Uj+8Y9VrsH19deov/JKtFSZw/ZRvLCFT0SR5XKhcdYsNL/wgspQsrKQ9fLL+oGE4qNdwP/PzlrUfLMTR3dz4bA0lUlYtzsZwwYegeP6ZqscosiY+95B/Omdvdq3UUt0oebXTeuex4xPnlIpw18HX4jbCqaqVGBJ2n//e0ZPTB99mMqxp7m5Gbt27UJjYyNaW1tVLmVnZ3sGfAn2tXt3YNAx/fXBzJOT2eMj5EOze/dubP7qO2T36segTxGjB/t39+L35/RFyag+6JXZtb5zdc8/j/233aZShj7l5UgbMUKlfNtb34qnP96LaUu34/YzetkO+hLsv/32W/Tt25cxzMKMYR57Y/3WXRjyg6PRr18/7igL2Rfy4TluQD/97IcoUma/uw/3XXgk7jjniC4X7EX66acj4yc/USlD06pVaso/2RdTtQOg7Bf97McmCWpHHnkkY5gXM4Z57JHhfVrRq1cvlSJvssOkq4soUlwuF648qadKdR31L72EPZMnY9eoUWh47TWVa0g59lg11bGpo/uoKXtqa2sZwwJodwjkA9T8k33D6xoUaV2pZV//z39il9aq33fzzWh8802V65Z8+OHIKCpSqY71ygw+HjGG+cdzHiKKCAn2+6ZORctXX6kcT+mnnIJeTz+tUhQPDPhEFBGN//63mvKUfvbZ6DF7Nnq/9BLSTjhB5VI8BBnwK3Cddrokp0zm67oKNcs2qWM0HtiiklFnXV+s102UwCqu8/guj/b4Ynh+Vyqu08p08GVPzclRU56ka2f///4v9stD2TZtUrmd0JYHMNpW/Ag3zkQvToXQwi/AvE0taGnRXkuvxuNjr9M2j4g6ky0PjEbKWGCpfI/11yZMWjjEd1DXDgxjsRQtjwTue8+eMgVZV1yhUu3VLVyI3ePGoWHpUpXTuWx5ZSHyr87HwleiEIljJLwunaIJuFpNarsDD4wO1FpQ865brPJM1nnmh804wl13nfahHP2AVnOguk12ylgFW56oq9gCLXZpDbdH4A7hgzD1mXkoeHyxVwNO+y7KgaGDYK/Tvkd6181f/4qsSZNUpidXbS32Xn89Ds6bp3I6C9ln+ZjwyATkL3xFSxl5EkPcYUs7Y9LjlfKK+wzKfRy1xrbrcF275UdrZxFj8TiqMG1I5ONSWAF/ywOz8HjBUAzWU9oH5j2ztbAU+dPmtn1wKrRPzNp5m4x5E6C9GTeZpzUz9BbGvLWzLKcxVVg79Bm0vDdVq9l/3W52ylgFW56oi9jyChZW5eP4QSptGnQRJhU8jsWWL8LCK2dhqMeBoWPpZ56JHvfcg74ff4wec+YgbdQoNcft0P33Y/9vf6tSnYDss/wJ2n4owoT8aZir76NBuGhSAR5XO6xi8eMomHSRliu0gL1hghFf2vWEmLHtEUy3LL/ls7Xa8s/gPS0eXa16Ut6b6v1HCk8IAd848shRa8iGmSogK219gnKEWovP9OBdgcWPF2DSRaqUx1mBzNMOAGNlmSGYVlWFDZvVLO0Nty0jfNbtxU4Zq2DLE3V5BRhqtOA0VajSvpOhdmEkH3EEsi6/HH2efx497rpL5brV/f3vaHj1VZVKbBVzpyF/gnHYK5qgBXAVpAddNAkFaz/TWvVb8Nlaa8zSAvZ0dZjUY541vrjLWZeXsy6PmBcFYfThS4t8rOfpyKyh2KRazO6g3hHLNQHt5fPM0U7dwa4/5O0l6uQGHY98Xw2cdi1/+W7K2e+VYV9AzLrsMuMunfx8lWOo7xT9+daGqfYaKwnV9SVnRViIVyq0fadNBR2vw10+SGF06Rh9fmutpyr5xxut/YrFlm6bwRhaYGklBJoXiM+6vdgpYxVseaIuoQjT50E7U7d2M2zBA1dOg9Ys9eq+KcIjS/Mx7UpL33SI5D78jLFjVcrgam5WUwlM4sPVS9sapfJaerXZ9TUIx+dXYcPiDdI8N+KJzh3XjK5vf8FcuoXgY/noCO+i7aCpeGbeWoyVCxVy2vL4WOMIuBiWFrNxYNA+XR3PS/Fzx4/fui3slLEKtjxRFzJo6nvYJN9d/XsnryFYOGmT7z7jokewNH8ahlgvSIbg4Ny5OOjVtePd4k9E0jd/terOMVm7dfTpx9d6dccUIH/Dlfq+HSLH0WcsXd9eBh2f77V8ESZcHZ2Lth5Py/ziiy+Q3wn+APG0du1aHBvEs0CIAul119do+VPXH+x737RpqH/xRZUypAwYgD5LliC5b1+V41vK7Ruw9/8do1KBdcYYJrfIDlk4CZus10OjJLwWvoXRSmj/IiJna9m+vX2w798fPR58sMNg37UZt3V2dAYQSRxOnoii7tujj96EpCT9/h8XsKEV+OXAb75Zrc+kmGHAJ6Ko++qYYwakuFzXJ7lcden19Q8esXv3fjWLYgb4/yZnbEpObrPaAAAAAElFTkSuQmCC)
https://support.microsoft.com/sv-se/office/skapa-en-listruta-7693307a-59ef-400a-b769-c5402dce407b
Det Kommer fram en Dropdown om du markerar med musen eller trycker ALT+nedpil
Villl du ha fram dropdown automagiskt när du markerar A1:A2 måste du högerklicka på fliknamnet och välja "visa kod" och göra en händelsebevakning i stil med Worksheet_SelectionChange där du kan använda intersect för att kolla om det är A1:A2 som är valt
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'tack och hej om du är utanför A1:A2
If Application.Intersect(Target, Range("A1:A2")) Is Nothing Then
Exit Sub
End If
'Tvinga fram dina val genom att "trycka" Alt+nedpil:
Application.SendKeys "%{DOWN}"
End Sub
https://learn.microsoft.com/en-us/office/vba/api/excel.application.intersect
Du skulle kunna använda Worksheet_SelectionChange för att visa ett formulär med en combobox också. Men där tog min ork slut.