PDA

View Full Version : Pull information from selected row via listbox



ecalid
09-27-2023, 02:22 AM
Good morning all,

I once again could use your assistance with something.

So I am trying to build a 'briefing generator' and I am missing a piece of the puzzle.

I am using the following code to pull our incident codes from a column in a table, into a listbox.

I need to be able to populate textbox fields with the information found on the row which corresponds with the selection found in the listbox.

So if column 1 is populating the listbox, I need column 2, 3 and 4 to populate the textboxes with the row address within the listbox selection.


http://www.vbaexpress.com/forum/image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAy0AAAG4CAYAAABIJAjfAAAAAXNSR0IArs4c6QAA AARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAFUwSURBVHhe7d0JfFXnfef/7z3aN4RYBGLftbAKEGAMGNsYMDu2ITh17LTTTpv/tJ1XO51O2 nk7/mn03amySRNDMQ7XjC2wYljBwHGGDCrLMBsRkIgQAiEVkBCy5V0pfu/53BIsKQrlFxzdUCft1/X6P6 91wJfCQ/D c8z8 VlJTklc/EiRP1wx/ UFFRUfrggw 0aNEi1dfX6/Dhwxo3bpxqamrU0NCguro6xcfHq1evXvr88881efJkJSYmauPGjVqwYAHHczzHczzHc3y7x5uve qpp6wa///heI7neI7n I4cH5Kfn//8n/3Zn2nZsmU6ceKEqqurrYOLior0/vvv6 GHH9bVq1f1zjvvaObMmQoPD9e6deuUkpKivn37WvXIyEiNGDFCO3fu1IULFzRlyhTl5eVp27ZtH M/xHM/xHM/xXzve/B/R0qVLrYmL XjwwQf58 N4jud4juf4do93nTx50nvu3DmlpqbqypUreuCBB5SVlaXCwkIdOnxEffr2U2hIqBobGxUWFmb9r ZinyaMQX83l 7ipuVkul0uG79Hs9crrbVaIEXLzdR6PQkNDrY85nuM5nuNNHM/xt46/HX9 HM/xHM/xHG 9zs/xri //NJ77do1DRs2TJcvX7Yuv/zqVx8pZUy6ho5KU89eib85EAAAAACCzfX66697hw8fruzsbP3xH/ x3n57vSJje2jEmIlqdhn2ywAAAACgc7jOnj1rXWnp1q2bdU/ZleIyTZ39uKK7dbdfAgAAAACdx7V7927v fPnrVX8P/nJTzRj1qMaOX6qPM3WpmIAAAAA0Klc77//vjc5OdnaWqx3796qq2/SkLRJcjc02i8BAAAAgM7jysnJsS6p1NbWytxFzOsK09DR5qTFY70AAAAAADqTa8uWLd5Tp04pIy NDa9eu1fInv6VhYyYzaQEAAADgCK6dO3d6hw4dqjNnzlhXW obvUxaAAAAAHRIU1OTqiqrVVdXL6/37qyLd 3bt8 bkJBg3RpmqnV7mLQAAAAA6JCSK2VqamxURGS41TTybnB9 OGH3vz8fOv2MHP3sFXfflbDx2TI3cikBQAAAED7zpy oP5JPRUZE6Xmu7QDsev48ePWlZaqqiodO3ZMoeHRTFoAAAAAdIg5aRk0MFFGaJiaW9we5vX94/L9Y6qqrFRNdbVZtMTGxVmPW1dnmpubVVl5Xe7aWuu5EWIorlu8oqNjZOTl5amkpER79 5VfHy89QIAAAAA6Chz4uEyfA/z1988DBnWw6WGhgadPHJY1aWXVVtRpOryy/ryi4OqKC/zHXxzFlN44YJyvjzsy69Yj5IL Tp98qQ8TZ6bC/Fzc3Ot5pLm7mHzFyzR8LEZqm9ssg7257eLbMwvyP7QV7PK5hd8s/J78/pmWrfP08zf9G8 z13i9Tb7/n3zDxkAAADAnZlXWoYM6iNXeLhvDH/7CP63zCssh/bs0n/7L3 q0NBQuevrtWXLTn158ozG eYhNTduqKjgvJYueFhpaaOsY86cOa/X3/lQMx99VEbfvn01e/ZsJSYmasqUKdYL7jzl8KrJfVVXL19Q3e09KBurVFF0UTV1DV bcPyuvE2Nqrx0VBdzv1Th6aO6dPYrXb8R2HveSbOnTnVXC1VeXKo7zNcAAAAA3M7lUoh5VcXw/zCZO4yZIiMitODxR5SRnqojWQdVeO6sljw zcTFlN1Ta09L/HK2L17t8rKyrRp0yYNGDDg5is6wNvcqAZ3nZrNixO3NHt8Nbeavlb8PXibra3TInuPVP8RY9Rva LK6xYbfcSr1 2qur1T5ueMqulygat E6y6tHwIAAADuay3H6zefuxQWFqbQyBht/MVmXb9eaVUjIsK1YP7Dmjw VSuWz9Po0clW3XT8RI5 8dE29e7bR6Gh4TKmT5 uq1ev6vHHH9fBgwdvvqoDswPzDirrZbe/9tbHvtDlm8DUV5WooviirpYUy914cyJjThAqSwt99UJV r7gJnOC4G1UXWWpqiuv6nqx77Wem5c6DN8XGBp28xFyc3J22/EXVVFWqnp7a ZmT61qK8tUfbVU10rKfPU61VaVqeaa77nvtdfKSlRf36C668W66vvc1yuu69ZWA15Pg4y4/urRu4dCfc878NsHAAAAYDPHz9YKC3Me8JuHFVm/hkdEKH1Khkqu3vBNXLaoqqraykJCQrR86TyNGjnMem46cTJXm365VfE9e2nYqJGKjIqS6 jRo15z0jJs2DC99tprGjNuokaOn3qHNS1eNdYUq6yoQnEDxygu0i67y3WpsEyxSYMV1XRN5SVXF RLbXeEet1y9hqibUeObMBSpKSxaYa4m1dfUKazXYCXENqk874TckUmKie6mmO7Rqr3ylTzxY5SY YL657zdtuOR1V6riUoEaIuIUGR4qT90N1Xtj1ad/PxmN5So5f07NMf0UG9NNUTEuXbtwUo2RvufRoaqvLFKdt7ti46IVanh8k5sqRQ9IVu/uMTe/djXoxpU8Xa3ppr6DBykizC4DAAAA8Ot07nkNHdxXoeERN9e927MVa cw31Ov76lvNG9lldeu6khWlnp2i9ayJY8pOjrKeu0t585d1KYPtyo2oYdSRqepR69E6wKGceTIE WsxzAcffGAtxrfe8jezo/Yfbb7Wqvm RN9EpUnRiu/TXz0GDFW3KJfqq0rl9kQorkcfxffq65ugGKq/USlPs 9jDBFxvdVr6Q ig4PlxrrVHXpK13MPapL edV1 hWXVW5GkIS1KvfUPXqO0iJ/ZIU1lCt2vpG3x G R6Riu3p 3yJvRQRYsgbEq7ohL7qmTRIPfr0lOHxKKrnIPX0HdsjPkzu6jo1f 3rN/ Mfb 22vmABw8ePHjw4MGDBw8e/h4dYU5a6mrrrOUkAwf0NSuqra392iMmNkp9fWP5G1U3ZISEKsQ3T7FmHWfPnvVeu3ZN3bp10/bt25XYd6BS0qd14ErLFZVcKle3QWOtCYnFXa7Ci6WK7T9Usa4bKj1/Vo1RfdU9obdiY1y6fvGkiq83KjIqUubdXuZuXeEJQ9S7Z4SuX8hTaL/J6tXNUHNTvSoufKnGuFQlJpizL3NhT4OvdkZ1Mf2VlNTbuo1LqlX5mbPyJAxW98galRdVKN739Z hXfjx111Ry byi 4xRQlyob3JUqNJL9eo5cpSijUbVlOSprLGXBg7qoxDrvRp140quKqq7KWnoYEXc/AQAAAAA2pGbc06DfWPqsIiI1mvDb7vyUnz5so5lZ2vKxFSNGT1KIfb6j6tXrys2Nkbh4Tdvdaqr c2vzll2qa3JpfEaG4uO7y7V7927vhQsXNGnSJKsj/tz5i5U68QHV2 tK/PHUlelKwSXF9EtTj24RVq25 oouXqpQj4Ej1S3GV2uqVWWJuf7E94UMGaGQqwWqjuivfv0TFWrPc8zfQ3NjpUrOnFbYwCnqFeeS 11Ovct kxZMwXkk97UtGvvequHDaOr7/reO91SrNOydv7yHqHl6tMt/njh9yc9LSZE5aLp1XVN xvklLiOqrCn3PG9Rr1EjfpMWjmuJclTb01qAht01ainJV7pu09BvGpAUAAADoiJxTvknLQN kJTLy5u1h1rWRW24 r3fXad9nO5Q6YoAmpo/ zdWZktJybdm2R/2Semv2rCm iUu4Va pqfXVP5crMlaTp02T67333vOmpKTo0KFD1rbHdfXNSps0XQ1N7e8A5vXUqOJirqqNfjcnIapXVd FZlTfGasDAgQppvKY6o4diwt2qOHtCDd1Hq7uKVVJSo4ThyYqPDldjbY2aXWEKD6tXqT1p6W1ea fG4VX7uiDw9Jqhfr2j7EzappjRfxcW3HV9VpJIrvueDhyqyuUIlheW Sct4dfPNczy1V1VceE7RSeN8k6oQuSvNSUu9b9KSrJiQRlVfsSctQ/vaV20aVHU5R2XV8eo/bIgiWdMCAAAA3NGpr85q0ID2Jy011Te0e8tmPfvMUoWG3LxkUFpaoS3b90ihYaqvq9eIwUmaOSN DYWE3R cFF4u0bWeWHp43V66cnBzznax7yPLz8yUjQqMnP3jHSYu5LbGnrlylly6pprbBKoVExqvnoBHqF umbTV3NV Gl676vsVkhsUnqO2CQIn2ThaqiPJVX3vAdbkjhceo9YITiIs1JylmF9ktXzzhz0lKva4Un1Bg/Wn17/HZxjlmvLT2v0qvX1WReCAqLVve w9QzIVpNtaX2xgCj7Sst11VaVKDIPmlKiDXXzhT58nr1GD7i5u1hvglQeUMPDRiU NsrLcVndLU6Vn0G 75WJi0AAADAHX118qwGD0hUeHSUdTdYW9MWs3nkri2/1pKFD1u3hZm3gH362UHf1CNSKWPG F7v0skvj6pvrzhNyRhnHXflSpn2fXFSD819TK4tW7Z4T506pYyMDKsj/vInV2lMxow7T1osXjU3eXwP 7VGyG8Wy5hXRjyN9qbCIWG GdXNe9a8zU2 CYevbv1uDBm mZXh8r2Pp9H3unCzmf7N1zU1WFdhQm4VbvG9b5On6eYs7jfHW4HvPTxy T7XrbVAzU2 9zRu5c2 45p9r7e/vmaPmrzGb 6lM3l97 378nyvCfnaHzQAAACAtp06eca6PSw8Otpe0 L7lzlU9w3Kby1pqa vV9aePSopuiyPb8we6htv9 jdW8mjR6tXn74K843py0tLdORglqoqr6u5uVkRERHqP2SwRo fINdnn33mNbc7zsvL88146lTvG ePnTKzg5MWAAAAAF3ZrUlLRHSMb9JizVps5mWA3z5vaGhQ9Y1KNdQ3WBOZ8IhIxcbGKTTcbCJvT nCa5fbNR2pqbsjT2Gh10Y/0vWdMTKxc /bt8yYkJOjcuXPW1QtzTcu4qbPUSFt4AAAAAHfw1Yk836SlryJioq0rK 3yveA3L/HNXKy7m74 t7HmJLfcvIPK97oPP/zQa65lMW8PM3cPW/Xt5zR 2kNMWgAAAADc0dkzBYqOCFNiYk/r6kibrMmHz60pxq3nt2tn uE6fvy4daWlqqpKx44dU2h4jG/SMlseJi0AAAAA7sBcVH/h3CXV1tZ97SrJN8m1adMm75AhQ3T48GENGDBANXUeTXjAnLTYrwAAAACAdtytycotrp07d3pzc3 M1efJka/ew QuWKn36w60mLeYKfnNxTEhI210XycnJycnJ20JOTk5OTt6W3yU3 vbtq9mzZ1uNJadMmWK/pLWL5/OVuelN9YpqbvNReeUMOXmbmfkgJycnbyszH Tk5ORtZeaDnPxW7lq7dq139OjRys7OVnJysmrdHqVPf6TVlZYww6vQxuvqHh9vV1qrrKxUPLn9r DVycnJyf8jJycn9IScnj7 5EN/c7njUqFFav369xqdntD1pCZF6mrMc zkAAAAABINh3itmzl6io6MVEuKbmQAAAACAgxhHjhyxJisffPCBtRgfAAAAAJzEmDVrlqKiorRo 0SJdvHjRLgMAAACAMxiXL1/WqVOn1NjYqKNHj9plAAAAAHAGo7i4WBMmTFBWVpaWLl1ql1sz1740eZrsZ61ZeRO5P Tk5OT kJOTk/tDTk5 MzfGjRun8PBwa JSV1dnFduSf/as3nrrLftZa/n5 eTk9rPWyMnJyf0hJycn94ec/Fbu2rJli9e8PSwjI0Nr1qzRE0 tok LH Tk5OT kJOTk/tDTk4eeO767LPPvMOGDVNeXp51paW 0UufFgAAAACOYURGRlqTFXMhvmEYdhkAAAAAnMEoLS1VZmam4uLi9Nprr9llAAAAAHAG1/Hjx70JCQmqqqrSsWPHFBoeze1hAAAAABzDMNeymFdb9u7d2 4iGAAAAADoDEaPHj30xRdfaOLEidq0aZNdbs3aJ5k Lfaz1sjJycn9IScnJ/eHnJy8Y7mRlJSk2bNnKzExUVOnTrWKbaFPCzk5uT/k5OTk/pCTk5P787vkrrVr13pHjx6t7OxsJScnq9bt8dunJazxelD2YfaHnJyc3B9ycnJyf8jJye/93HXs2DHvuXPnrAnL vXrNT49g4X4AAAAABzD8Hq96t69u2JiYhQaGmqXAQAAAMAZjCNHjigkJMRahD9p0iS7DAAAAADO YMyaNUtRUVFatGiRCgoK7DIAAAAAOINx fJlnTp1Sh6Px2ouCQAAAABOYhQXF2v8 PE6ePCgli5dapdbs/ZJpk L/aw1cnJycn/IycnJ/SEnJ 9YbowbN04RERFKT09XbW2tVWyL1aflbWfs09wWcnJycn/IycnJ/SEnJ783cteWLVu85u1hGRkZWrNmjZ54ahV9WvwgJycn94ecnJzcH3Jy8sBz12effeYdNmyYTp8 LbfbrfpGL31aAAAAADiGERkZqbq6OmshvmEYdhkAAAAAnMEoLS1VZmam4uLi9Nprr9llAAAAAHA G1/Hjx70JCQmqqqqytjwODY/m9jAAAAAAjmGcOXNG5tWWvXv3trsIBgAAAAA6g2FeZfniiy sLY83bdpkl1uz9kmmT4v9rDVycnJyf8jJycn9IScn71huJCUlafbs2erTp4 mTZtmFdtCnxZycnJ/yMnJyf0hJycn9 d3yV1r1671jh49WtnZ2UpOTlat2 N3TUtYw7Wg7MPsDzk5Obk/5OTk5P6Qk5Pf 7nr2LFj3nPnzlkTlvXr12t8egYL8QEAAAA4huH1emWua4mJiVFoaKhdBgAAAABnMI4cOWI1lTQX 4U aNMkuAwAAAIAzGLNmzVJUVJQWL16sgoICuwwAAAAAzmBcvnxZOTk5amxs1PHjx 0yAAAAADiDUVxcrHHjxunAgQNasmSJXW6tubnpjn1aPB6P/aw1p fA3eT085 cnJzcH3JycnJ/gpkb5oQlIiJCEydOVG1trVVsS/7Z/Dv2aXn77bftZ605PQfuJqef/ Tk5OT kJOTk/sTzNy1detW71dffaWMjAytXbtWy5/8Vpft0wLcTU4//8nJycn9IScnJ/cnWLlrx44d3uHDh v06dNyu92qb/TSpwUAAACAYxjmzmF1dXVqamqytj7uump1du82ZW45pqpGu6TrOvLLD/X58SuqbzGJ /rrPSrL/1w/ u/1l/91V/pb//u7/WrL8vl8dov7QCvt1mNDcU6sOF9fXasrc8HAAAAdE1GWVmZMjMzFRsbq9dff90ud0WNKjv7lU6eu qy630wYItR76AgN6tdd4fKo nq5ioqKrEfJtQqdP3ZQ /cf07lLFbpWUajLl8M144lntCA5XB sV3nG5ukJrcqiq/4jrmi8us1volMk2oqilVeWSfr0zTWqLi4QhVXzur9H/1n/f2/vqovCq r6XeY8AAAAAD3s5B/ Id/eN5cz2JeZenZs6eMkDAlDRyq5haD5hBDig7z3se3h9Xr0tEvdbGulyZMGanYULNWpp2r39HpiEE aFHZRb//7v ln723Wzr2f6JMvS3Tj FZtzTqpgste9RpiqOJ8pB76zhINNwq1c0 1pi0ZK8/RX mHvonIBx9t06HcCsUO6q38La/ola35GjRulJq 2KAfvJKlnhkP67HZ42ScvqzQkZM0YWRvhXXlC18AAACAzThz5oxKSkq0b9 dhfBdE1eNdTVqq62SuePfqZjJYP0P/59nV78yT/pzxYt0NzHlurJVX lH/zLH2lsfIhK87/QpnUvad2He VKT1Pfugva NpO9VnyF1r78j/robjzysw8rdHLntOMyFP68K1f6OXPcjXt8UWaPjBW0XE9FBcdIeYqAAAAwG8ZCQkJysrK0oQJE7 Rx40a73FqX7tNihKt/8kSNiM/Xj7//t/rB/3pZV2Ni5TVCrCtUIaEhcvmmGiGh4YqOiVPPpN5KqLikooJyFRj9NHB4b0XH99CwkfEKrylRU hAPbJksRq/2KGLiTM1e8YwRVpXdnC/cvr5f6ccuJucfv6Tk5OT 0MevNxISkrSww8/rMTERD3wwANWsS1mn5a3u2qfFleoovql61t//rf6L3/6jBakhOtX6z9TgadBTU3N5gUZn1D1GjxBC1Y8rWULM9RwdLvyrhqKqKtS XW3mpobVFNd7/uDD/VNcBpUWlik6w2GqkqOq7DUffMtcN9y vl/pxy4m5x /pOTk5P7Qx683LV27Vrv6NGjlZ2dreTkZNW6Pe30abmu PhudqW1qqoqdet2r aVOrDu5/rVsQjNXDZVPcJD1a1XiI68uFE105dras/T2nMhURkjY3X9/GHtvzJAswbmausBl2YuXqzBkUf07r9/pfQ/Wazo0x9qw/E ut/ gNdffNH qhihJY/2EeHdx5W5OzlmtO3QFszD2nMsj9U45afaa8xXd95er5ib zV2//8gWrS52vpwtmakNxHES42mb5fOPv8v3MO3E1OP//JycnJ/SEPTu46duyY15zFpKSkWDOZCROndNE LW6dz/pEv/jFfpUb5u8yVslTpmuIUa2wYeM1stsl/fKlzbrQ7FVUt2Ga9 y3NdY4r1/ 4kOdrx6ux5Yl6ct1W1XgOzIiJl4PPPGfNCc1Tt7rufrFWx/p JVa9R/7kBYvTlfRrl/qWNRU/eEjqfIWHdabm7PUZ8IcNR97S/vPeaTQKPUbv1DffXKSullfCwAAANB1uY4ePeq9fv26hg4dam15nDZmAs0lAXzNlfPn9cbatSppr FdjvUch4eEy59O90x/XHy57WEndwuxXtueavnj3U1WnztD0sfG6tD9T772/V UhLsX0GqDH/ DP9eCQCPu1d Zt9qjeXahdr 1Tz8VLNWlQnPU1AQCA 0/IlClTnje3Ov700081ZswYeZq8XXTLYwD hEdGKrFfP6WN7qb8D4 rz8JVWvroNI1PHal PWMlT40qSsp1vapKTWGxCpNb169Vqjk0XOG Hx4N1VdVUn5ee9Z/rHxXLw3tH61LX zWV2V99PhTjyru0iFtORmqSTOGK9r3XuXF5nvVqDkkXBG nztVFeVye0MVER4quStVdt2tGxe/0Ks//r5e3XhWAxcs0rg UeJuSgAA7k8hP/rRj55vbGzU PHjdfjwYcXGxTNpAfA1oWFh6t23r/r0blZuZq76P/EtPTp qHp3j1GI64aObnlJ//aD17R192adKEpQv 6l2vDCWp1w91TqQGnPiz/QP7y4VcdOHNPxM dVejVUcTF1aghP1txFDyj22lkdLYjWgw8PUMFHP9e//mi9Nm/5VMeLXeqV5NLu1/9dv85tVHJaks699xP928eXNWbuQj3y4FBV7i9Q79kPK41JCwAA9y3D7O6em5src Jy/PhxuwwAHeFVTeFhbfv4gub 8xq9/O//XX1yMnUmNFnPPD1DZZ/vVGbmBmWe66Xnf/J/9CcPP6Zn//P39T/ 6xINDKlXfvY2vfXKy/ooO08JE1IUW3pYb7x9WtP 5kd6fe1fq2fudu3MdWneM6vU /JBbf5gg14/Uq8F33pCaT0iFNutu6LD2C8cAID7nXHlyhWNGzdOBw4c0JIlS xya81NZp W4OzD3Ja7nQN3k9PP/zvlfnmb5S74Sp99ma PX/6B/tsPXtT wqM6d0lKGvOY5qeGKvODfA1Y R1lDDTXwRh2byNDLt8/IeFRiovvrtjoSOlSgcoLSlQQn6rUYdEK6zVAY4c2qKa8RtF9xmv Q2N14uP9in5kuR4bF68QrqrcN5x /pOTk5P7Qx683DAnLOHh4Zo4caJqa2utYlvMHcbeCtI zG252zlwNzn9/L9T7pfX/IESqqikkZrz1Lf13T/8nv7u X/VE5N7qbnmis5f8ii2W7kK88 qut6859Sj3/aojdSQ8bO0bNUqPT5rqMqP7NXl2jBFVpXrWnWDvJ46Xa/y iY5LjXXX9flwqtqDnfrYs5RlVxvtN8D9wOnn//k5OTk/pAHL3dt3brV 9VXXykjI0Nr167V8ie/1UX7tAB3l9PP/zvlpqaGk1rz7Kvq8w/f11NjE2S4vKorP6k3fvpzVQ9drOmjYlV6Jl/dZs5U0563dMwzXnOnxmjLCx o xPfVsL d3UwdJqeXJCu2uObteN4pGYuSFNF9kfa2zBDf/vn6dr3v3 sE0lztGz4DX2QWagZ33taQ0p36ZOjdZqzbJZOvbxaVyZ8V08/MlLVlz7Ruuc/UY/v/Acte3CcRg1MkO9HFe5BTj//ycnJyf0hD07u2rFjh3f48OHWupb6 nrVN3rZ8hhAm5o8Rdr/brZiHp2n9KRI dBoyoKvtCmlzJ1wetSt2EP6snH unw7qMaNmOJpgyM0MUvfqVfno3S7JRu nzXQXnixmlaepMOfHjA6osU26u/5n3rTzWpf4huXMzS nVbVegO19g5S/VoeryObvm1alIWa1l6kq7nfKrXdxYofdI4FRz8lXKLfT sIntowiNPaNlDIxVpfU0AAOB 4jpw4IC3e/fuOn/ vJqamlRX38SkBQAAAIBjGKWlpcrMzFRsbKzVXBIAAAAAnMR1/Phxb48ePWR2xTe3PA4Nj ZKCwAAAADHMM6cOaOSkhLt379f8fHxdhkAAAAAnMFaiH/69GlNnjxZa9as0YJFy9q80hKiJvWIbFJoaNuN3Mx9lM3HvZR7vV6rBgQiJCTk9zr/buf0nO8VAABwu2CPf1w5OTlel8ulyMhIbdu2TQk9 7Q5abmQn6fcL/fqD7/7XbvydeYVm3379um791BuNtY0J2zA78tslPjAAw9YVys//fRTR53ftws0r6ys1LFjx6wfHAAAoGvrjPGP6 c//7k3LS1N2dnZSk5OVq3b43dNy/3Wp XChQs6evSoampqGIzh99KzZ0/NmzfPurWyqKjIUed3S4HkV69e1d69e60GtI2NNHYEAKAr64zxj vYsWNes9tkSkqK1XFywsQpXWYhvjlp fLLL61ZXGpqqiIiIuwE6Jhhw4Zp7Nix1iXS6upqu3r/uTVpOXfunAYOHKi4uDg7AQAAXU1njH sSYu5c9iQIUOsLY/TxkzocpOWS5cu6S//8i/bneUBbTG/d6Kjo7vMpMX8nnnmmWc0dOhQOwEAAF1NZ4x/jMOHD8tc07Jp0yZNnDjRLgMAAACAMxizZs2yFuEvXrzY ltUAAAAAHASw1w8k5ubK4/HoxMnTthlAAAAAHAGa9Iybtw4q7nkkiVL7HJrzU1NavJNbPwxd98yJz7 OD0HAtFkfn/4Hv44/fy/Uw4AANBSMMc/xvjx4xUeHm6tZzG3/vXH3GHM3F3Mn3s9BwJhnl9vvfWW/ay1zj6/A80BAABaMscPwRr/uLZu3er96quvNGXKFKsj/vInv9Wl rSwexgCcfvuGV2hTwu7hwEAgM4Y/xhhYWF64oknrKssTz/9tB23rVs7ExZTe5/Q5PQcCITTz 9AcwAAgJaCNT4xzFmS2 2W1 u1tj4GAAAAACcxSktLlZmZqZiYGKu5JAAAAAA4iWHem75y5Ur16NFDK1assMsAAAAA4AzG2bNnZ V5tMbc85p52AAAAAE5jxMfHKysrSxMmTNDGjRvtcmv0aQH8o08LAADoaoLap6Vfv3565JFHlJiY qAceeMAqtuWb3Ge5LZ2dA4Fw vkdaA4AANBSMMcnrp///Ofe0aNH64svvlBycrJq3R7/fVoaryu nVvIvql9mP35pnP6tCBQ9GkBAABdTaf0aTGvrpSVlWn /Pnat2 fHbetvTc03es5EAinn9 B5gAAAC0Fa3ximP/q2bOnYmNjFRkZaRUBAAAAwCmMw4cPW00lN23apPT0dLsMAAAAAM5gzJo1SxEREVq0aJF1vzoAAA AAOIlhLp7Jy8uztis7ceKEXQYAAAAAZ7AmLWPGjLEW4S9ZssQut0afFsA/ rQAAICuJqh9WsaPH2/dHjZp0iTV1NRYxbYEcx/mttztHAiE08/vQHMAAICWgjk cW3dutV76tQpZWRkaM2aNVr 5Lfo0wJ0EH1aAABAV9MpfVpCQ0O1fPlyVVdX6 mnn7bjtrX3hqZ7PQcC4fTzO9AcAACgpWCNT4yYmBi53W7ribn1MQAAAAA4iVFaWqrMzEyZk5fXX 3/dLgMAAACAMxhDhgzRypUrlZCQoBUrVthlAAAAAHAGw1yVb15tOXDgAPe0AwAAAHAcIz4 XllZWZowYYLef/99u9wafVoA/ jTAgAAupqg9mnp16 fHnnkESUmJmr69OlWsS0390lebz9rzczXr793cyAQ5vl1p33GnXz 3ykHAABoyRw/BGv843rxxRe9aWlpys7O1qhRo1Tr9tCnBegg rQAAICuplP6tEydOtVa0zJv3jzt27fPjtvW3hua7vUcCITTz 9AcwAAgJaCNT4xzN4svXr1UmxsrCIjI60iAAAAADiFcfjwYaup5KZNm5Senm6XAQAAAMAZjJkzZ yoiIkKLFi3S fPn7TIAAAAAOINx5coV5eXlWduVnTx50i4DAAAAgDMY5or/MWPGWIvwlyxZYpdbM/u0fFP7LLels3MgEOak38nnd6A5AABAS8Ec/xjjx4 3bg bNGmSqqurrWJbrH2S29mH ezZs 3u0 z0HAjEnfYZd/r5f6ccAACgpWCOf1xbt271njp1ShkZGVqzZo2WP/kt rQAHUSfFgAA0NV0Sp W0NBQLV 3LrK8vTTT9tx29p7Q9O9ngOBcPr5HWgOAADQUrDGJ4bZn8XtdlvbHgMAAACA0xglJSXKzMy0LvG sW7fOLgMAAACAMxhDhgzRypUrlZCQoBUrVthlAAAAAHAGw1z1X1ZWpgMHDnBPOwAAAADHMeLj43 Xw4EFNmDBB77//vl1ujT4tgH/0aQEAAF1NUPu09OvXT48 qgSExP14IMPWsW20KcF8I8 LQAAoKsJap WF1980ZuWlqbs7GyNGjVKtW6P3z4t4Y3X272F7Jvah9mfbzqnTwsCdfs 5VeuXFFcXJydtOa087 l9nL6tAAAgFs6Y/xjTJ06VaWlpZo3b5727dtnx22La cNTe19QpPTcyAQ7X3Dmpx /t8pBwAAaClY4x/D7M/Su3dvmf1aoqKirCIAAAAAOIVx PBh64NNmzZZi/EBAAAAwEmMmTNnKiIiQosWLdL58 ftMgAAAAA4g2EunsnLy7O2LDt58qRdBgAAAABnMIqKijRmzBhrEf6SJUvscmv0aQH8o08LAADoa oLap8Vcx2LeHjZ58mRVV1dbxbbQpwXwjz4tAACgqwlqn5atW7d6T506pYyMDK1Zs0bLn/wWfVqADqJPCwAA6Go6pU9LaGioli9fbl1lefrpp 24bfRpAfyjTwsAAOhqgtanxezP4na7ZfZrAQAAAACnMUpKSpSZmWld4lm3bp1dBgAAAABnMIYMG aKVK1eqe/fuWrFihV0GAAAAAGcwzp07p7KyMmVlZXFPOwAAAADHMczFMwcOHNC4ceP0/vvv2 XW6NMC EefFgAA0NUEtU9L//79NWfOHCUmJurBBx 0im252ael/X2Y77RPs5NzIBAd2af8Xs4BAABaCub4x/Xiiy9609LSlJ2drVGjRqnW7aFPC9BB9GkBAABdTaf0aZk6darMHcTmzZtnDUraQ58WwD/6tAAAgK4maH1azP4s5q1hZr8Wc8YEAAAAAE5iHDp0yPpg06ZNmjBhgvUxAAAAADiFMWvWLIWHh2 vRokU6f/68XQYAAAAAZzDMxTPmynxzS7GvvvrKLgMAAACAMxhFRUUydw/bs2ePFi9ebJdbu1Ofljvt0 z0HAiE08/vQHMAAICWgjk Mcx1LJGRkcrIyFB1dbVVbMud rTcaZ9mp dAIJx fgeaAwAAtBTM8Ylr69at3pycHGvSsmbNGi17YiV9WoAOok8LAADoajqlT4v5yZYtW2YVVq1aZcd to08L4B99WgAAQFcTtD4t5idyu90yDMMqAAAAAICTGGY3/MzMTOsSz7p16 wyAAAAADiDMXjwYK1cuVLdu3fXihUr7DIAAAAAOINhNpQsKytTVlYW97QDAAAAcBxrTcuBAwc0b tw4vffee3a5NatPS2Nw9mFuy93OgUA4/fwONAcAAGgpmOMTo1 /fpozZ44SExM1Y8YMq9gWa5/kd4KzD3Nb7nYOBMLp53egOQAAQEvBHJ 4XnrpJW9qaqqys7M1atQo1bo97fRpqVS3bv63Nbtx40a72545LadPCwL1u xT7rTzv6X2cvq0AACAWzpj/GNMmTJF5g5i8 bNswYl7YlrZ8Jiau8TmpyeA4Fw vkdaA4AANBSsMYnhsvlUp8 fRQbG6uYmBirCAAAAABOYRw6dEher1ebNm3S PHj7TIAAAAAOIPrzJkz3oqKCiUkJGjLli3qN2CI3zUtPaOa5bKf3w9Y04JA3X5PZ3V1tV29/9xa01JVVaWFCxcqKSnJTgAAQFdjjnnM27aCOf5x7dmzx1tQUKBJkybpxz/ sebMXcCkBeigrjJpcbvdKiwsVO/evRUfHy/ztlIAANB1mctKzPFA0CYt7777rtfcNcy8Tcz829O6 qY2Jy0halJCRJPCwkLtyteZ yibt5mFht47OZMWBOrWpMVk7m7hpPP7doHm5qSMNW 4W5qbm62Hv/OPnJycnNyZeWNjY9DGP67c3FyvWWhoaFBOTo5Cw6PbnLRcyM/T6S/36bvffc6ufF1eXp7VpPK55 6dnEkLAnVr0mLuI759 3ZHnd 3CzQ3mRMX4G4wz7/9 /f7/v/yXbvydeTk5OTkzs3N28eDMT5xbdu2zXvq1CllZGRozZo1WvbESvq0AB3UGfuU 3O3c Bucvr5T05OTu4PeXBy1/bt270jRoywrrKYbfLdDc2saQE6qKusaQEAAOhMrqysLK85WL948aLq6 uZtAC/g64yaSk6f17rXnhBxY31aqxrlBEZoRDfD4PE9AX6oyceVb/4MPuV7bmqrHe260bqTM0Y112F 3 tDe/uUbnvjWJ6DtCCZ/ zZgyN6ODPmBrl7d2ije99rhJXiOL7jtVT//EZje8VbucAAOB YhQXFyszM1NRUVFat26dXQaA3 qVlKQnv/td/dF3H1WPIreGzXpKf/THf6KVcyapZ0yoPPU3VFJYaP3lR0VNkzwNtSovKdUNt8c6vv5GhQoL83V03z4dOpKjopIKFeVfU F1Uqp54 tuaGFWuje/uVqnvtV5PtUouXVLhxcu6esOtZq9H18uKrY 9Zu6 ruJLV1Rwo0mDZyzXH31nhQY1HNU7vz6iG9ZnAwAA95uQv/u7v3veXM9iMrczNULClDRwqG gYJV I8SQosO899WVFvNvyc1Jm9l7YurUqYqIiLAToGPMrYDDwsJkGIa1mcX9KiQ0VL369FHvnk3Kycx Vv Ur9fDYweoVH6MQ1w19mfmS/u8/v6XtezN1/FJ39etRrvdWr9Uxd0 lDfDq85//L33/1e06fvKYTuYXqLwyVN2ia1UfNlJzFk5VzLUzOloYowcf7q8LH67V//nJe9r2yU4dLfJNmPq5tGfdT/XxqXqNSktS/rs/1g 3VerhJ5/UrPThGpCYoNq8fdp1qaceeThF7HEGAMD9xzh//rzKysqUlZXF7VEAfkde1RQe0raPCjT3X1brpX//RyWdzlReyCg98wcPqeLznfr15g3KvNBbz//4f tPZj m7/zl/9A//tclGhDi1pmDmXr952v1y6zT6jEhVbElh/XG jOa9jc/1Gtr/0qJeZ9qZ45L877zbfW98oV vekdvX7Mo0WrntSYXtGKCDPkvnpaR/PLNGpcsvgJBgDA/ckwV ObW4mNGzdO7733nl1urbmpSZ7Gm7d6tMXcNtlcyO P03MgEE4/vwPN/fI2y33hlD47elYfrv1/9V v1p7C4/r/GWpb9qjmp8Wpq2/PKdB33pGkwaEWU2ozIdh H6VoYiYburVp696xEerueCcyi6W6mL3VKUMjVJIj/4aPbRRtVdrFNV7rOY9NE6nMg8o5uFlenRMNxkurxpq8vXrl97UubiH9AePjFKk/WXh3uL085 cnJzcH/Lg5Ub//v01Z84cJSYmasaMGVaxLWYfivXr19vPWrvXcyAQTj /A8398krNClNs/xTNW/Wc/uOf/qX 8f/7Vz05uZeaqi8rv9CjbglXVZCXpxv15j2njb4fPjcPlW KMWjsDC1 6inNnT5Y5Uf3q6guXFFVZbp6o0FeT62uVTYrxDDU7L6miwXl8kY06uJXX6r4Wp3cN/K1 cXXdDRsmv7Dn67SsATDfl/ca5x /pOTk5P7Qx683PXSSy95U1NTlZ2dLbMzfq3b479Pi6dS3YKwD7M/33TO7mEIVFfr09LUcFJrnn1Vff7h 3pqbIJ1taOu4pTe/ulaXR0wT9NGxqrsXIESZs2QZ8/bOtE8UfOmxWjrz95XzNJvq1fW 9rvmqQnHp8o98mt vRoqB6cn6arRzbrYPND tv/NEH7/ 3H rLHQ1oyvFq/2l6smd9bqYFXdunT4/Wau/wh5bzyggqSH9eQis/1flaTFq54XClJMQqL66mRo5LVK6btrrpwNqef/ Tk5OT kAcnD/nBD37wvLnjzwMPPKCPP/5Y/foP9LsQv3tMeLsL8e 0kN1pOQvxEajbF Kbtz21J9jnd0uB5hZvk5qaIpU0Jll940J9Pw9cCotO0LARvVWwc7eOnC9QTfc0PTAqShcuNWj8r LmaOGyoBid6dOqSR5OmT1LtlTxdqojW8HG9VVVwVmcvXVJD9 H61ne o9GJPTU8tY Kj2Tp6KV6TVqyVA8ld1PByTx1n7pMs9N87zUgRjknc6T4gQoPdauq7JLOnTunompp4LBk9Y5l0n Iv6uzzm5y8PeTk7SEPTu46fvy4t7KyUoMGDdKbb76p5NSx9GkBOojmkgAAAHefYd4W5vV6tWnTJ o0fP94uAwAAAIAzGLNmzbJub1m0aJF1iwUAAAAAOInVEd9cmd/c3KxTp07ZZQAAAABwBteGDRu8ycnJOnTokJKSklRX39TmmpYQNSkhoklhYW0vcjX3UTZvMwsNvX dy1rQgULfWtJjM3S2cdH7fLtDczMy/2AAAADCZYwZz/GCOD4IxPnHl5uZ6zUJDQ4NycnIUGh7d5qTlQn6eTn 5T9/97nN25evy8vKsJpXPPXfv5ExaEKhbkxbzauX27dsddX7fLtDc3Kzj6NGjTFwAAIC1a r06dNVUlKiHTt2BGV84tq2bZvXvC0sIyNDa9as0bInVtKnBeigrtKn5erVq9q7d69qa2utv AAAABdV69evTR//nxr7Bys8Y9r /bt3hEjRljrWcy/RfV3exhbHgOtdZUtj29NWszNOgYPHtzuDxcAAHB/Gzp0qMaMGRPU8Y8rKyvLaw7WzQaT9fX1cjc0M2kBOqirTVrM75lnnnnG mEFAAC6ps4Y/1i7h2VmZioqKkrr1q2zywAAAADgDIZ5q8fKlSsVHx9v/QoAAAAATmKYt3uUlZXpiy 4D51AAAAAI5jxMTEWFuJjRs3Tu 65dbq25qUmeRo/9rDVz2 TGxkb7WWtOz4FAmOeXx9P 98e9nAMAALQUzPGJ0b9/f82ZM0eJiYmaNWuWVWyL2Ydi/Tvr7Wetmfk777xjP2vN6TkQCPP8Wr /e PezkHAABoKZjjE9dLL73kTUtLU3Z2tkaOHKlat4c LUAHdbU LeweBgAAOmP8Y0yZMsX6ZHPnztWePXvsuG3tvaHpXs BQDj9/A40BwAAaClY4xPDbMOflJSk2NhYBi0AAAAAHMcwbwszO Fv2rTJWowPAAAAAE5imIvvw8LCtGjRIp07d84uAwAAAIAzWB3xzcmK1 vVqVOn7DIAAAAAOINh7pyVmpqq3bt3a/HixXa5Nfq0AP6Z59ed9hl38vl/pxwAAKAlc/wQrPGPkZ6eroiICJm7iJlbivlj7ZNMnxagTeb5dad9xp18/t8pBwAAaMkcPwRr/OPatm2bNycnRxkZGVq9erWWPbGSPi1AB9GnBQAAdDWd0qfF5XJp6dKl1id/ umn7bht7b2h6V7PgUA4/fwONAcAAGgpWOMTIz4 Xm63W YOYuZifAAAAABwEqOkpESZmZmKjIzUG2 8YZcBAAAAwBmMgQMHauXKlTKvuKxYscIuAwAAAIAzGAUFBSorK9MXX3zBPe0AAAAAHMeIiYnRgQ MHNG7cOL377rt2ubWbfVq mX2W29LZORAI8/yiTwsAAOhKzPFD0Pq09O/fX4899pgSExM1a9Ysq9iWs Y zN/QPstt6ewcCIR5ftGnBQAAdCXm CFofVpefvllr9kRPzs7WyNHjlSt2 O3T0uEp7LdW8i qX2Y/fmmc/q0IFC371NeXFys2NhYO2nNaed/S 3l9GkBAAC3dMb4x5g8ebKKioo0d 5c7dmzx47bFtvOG5ra 4Qmp dAINr7hjU5/fy/Uw4AANBSsMY/hjlD6tevn/UJGbQAAAAAcBrDvC2sublZmzZtshbjAwAAAICTGDNnzlRoaKgWLVpkLXYBAAAAACexOuKfP39eX q9XOTk5dhkAAAAAnMEwd85KSUnR7t27tXjxYrvcGn1aAP/M84s LQAAoCsxxw9B7dNiLsZPTk62bhPzhz4tgH/m UWfFgAA0JWY44eg9WlJSEjwmh9MmzZN3/ve9 RuaKZPC9BB9GkBAABdTaf0abl27ZpuPe6EPi2Af/RpAQAAXU3Q rRY/wYAAAAAhzLM2zzMR1JSkl0CAAAAAOcwzMUtO3bssNZ0tLcQHwAAAAA6g1FaWqrKykprdb7ZqwUA AAAAnMSIiorS/v37NWbMGL377rt2uTX6tAD mecXfVoAAEBXYo4fgtanZcCAAXrsscfUp08fzZo1yyq25Wz Wfq0AH6Y5xd9WgAAQFdijh C1qfl5Zdf9qampio7O1sjR45UrdtDnxagg jTAgAAuppO6dMyefJkFRUVae7cufr888/tuG30aQH8o08LAADoaoLWp8WcIfXv39/6hFxpAAAAAOA0hnlbmLnIZdOmTRo3bpxdBgAAAABnMGbOnGn1Z1m0aJG12AUAAAAAnMQoKSnR fPnrR4tubm5dhkAAAAAnMEwd85KSUnR7t27rast/tCnBfDPPL/o0wIAALoSc/wQtD4t6enpioyM1NSpU1VVVWUV20KfFsA/8/yiTwsAAOhKzPFD0Pq0bNu2zZuTk6OMjAytWbNGS5evoE8L0EH0aQEAAF1Np/RpcblcWrp0qa5du6ZVq1bZcdvo0wL4R58WAADQ1QStT0v37t3ldrsVERFhLcYHAAAAACcxzEs6m ZmZ1qTljTfesMsAAAAA4AzGwIEDtXLlSms9x4oVK wyAAAAADiDcfHiRZWXl vQoUPc0w4AAADAcYyoqCjt27dPY8aM0YYNG xya/RpAfwzzy/6tAAAgK7EHD8ErU/LgAEDNHfuXCUmJuqhhx6yim05e/bsN7bPcls6OwcCYZ5f9GkBAABdiTl CFqflpdfftmbmpqq7OxsjRw5UrVuTzt9WqoUF d/W7Pq6up2tz1zWk6fFgTqd9mn3Gnnf0vt5fRpAQAAt3TG MeYPHmyioqKrKstn3/ uR23LbadCYupvU9ocnoOBMLp53egOQAAQEvBGp8Y5gypf// ViE Pt4qAgAAAIBTGOZtYeYil02bNmns2LF2GQAAAACcwZg5c6Z1P9qiRYusxfYAAAAA4CRGSUmJCgo K5PV6dfr0absMAAAAAM5gmDtnJScna9euXdbVFn/o0wL4Z55f9GkBAABdiTl CFqflvT0dEVERGjatGmqqqqyim2hTwvgn3l 0acFAAB0Jeb4IWh9WrZt2 bNzc1VRkaGVq9eraXLV9CnBegg rQAAICuplP6tJhPlixZYg1KVq1aZYX 0KcF8M/p53egOQAAQEvBGp8YCQkJcrvd1i1i5mJ8AAAAAHASw7ykk5mZaU1a3njjDbsMAAAAAM5gDBgwQC tXrlRcXJxWrFhhlwEAAADAGYzCwkKVl5fr8OHD1sQFAAAAAJzEiIqK0r59 zRmzBht2LDBLrf2Te6z3JbOzoFAOP38DjQHAABoKZjjE v2sLlz5yoxMVGzZ8 2im3JP3tWG76hfZbb0tk5EAizj1F7k36nn/93ygEAAFoK5vjH9corr3hTUlKUnZ2tkSNHqtbtoU8L0EH0aQEAAF1Np/RpmTRpki5fvmxdbfn888/tuG30aQH8c/r5HWgOAADQUrDGJ4Y5QzJvETML8fHxVhEAAAAAnMIwbwszF7ls2rRJY8eOtcsAAAAA4AzGzJkzr fvRFi1aZC2mAQAAAAAnMUpLS1VQUGA9OX36tPUrAAAAADiFcfHiRY0aNUo7d 60rrb4E8x9mNtyt3MgEE4/vwPNAQAAWgrm MSYOHGiIiMjNW3aNFVWVlrFttCnBfCPPi0AAKCrCWqflk8 cSbk5OjjIwMrV69WkuXr6BPC9BB9GkBAABdTaf0afF6vVqyZIkqKiq0atUqO24bfVoA/5x fgeaAwAAtBSs8YmRkJAgt9tt3SJmTmAAAAAAwEkM85JOZmamIiIi9MYbb9hlAAAAAHAG15EjR7y 9e/dWeXm5teWxERrpd01Lz6hmuezn9wPWtCBQt9/Tad5zeb 6tabF/D0 /vjj6tu3r50AAICupqamRnFxcUEd/7g ugj78CBA WbvFgDkZq6RiYtQAd1lUlLfX29CgsLZf4FR3x8vF0FAABdVUxMjFwuV/AmLdu2bfOeOXNGkydP1s9 9jO/u4cZalJChEfhYWF25evMfZSbm5sVdg/lTFoQqFuTFlNVVZWjzu/bBZqbkzLzhxNwNzj9/CcnJycnbztvaGjQjRs3gvL5XadOnfKGhobKfHz22Wfq1r1Xm5OW82dP68yx/Xruuefsytfl5eXpwIED91TOpAWBujVpMfcp37Fjh5599lk7 Tonnv 3u1NuMicuwN1g3pp88OBBv cfOTk5Oblz83379vnNv8nxieuVV17xpqSk6NChQxoxYoRq3R7/fVqaqhTXzrZk5uWh9rYtc1rOpAWB6ox9yv252zlwNzn9/CcnJyf3hzw4ucs3aPeas5gxY8Zo3bp1ypj6IGtagA7qKmtaAAAAOpPrxIkTXvNetP79 2v9 vUaMSqNSQvQQV1l0lJ07pxe/elPVdxYr4aaBoVERyrE98MgceJC/fFTj6l/fNv3on7dVR14e6tupD6kWRO66 Lej7X nd0qDzUU3bO/Fj7313poeGQHf8Y06OKXn r9936t8zdCFd9nrFZ87zml9w63cwAAcD8JmTx58vNmg8lPP/1Uqamp8jR5lTRwqJpb9JkMMaToMO99NWkxB5zmLT3mAuqpU6davWqA34XZmNVcHGYYhrUY7X4V6 ZuYDRw2TBPSe rCr09p0JPf1crHZ2nSmFHqmxArNd5QyaUrKr92TZ6wOIWrThWlFfKERioiLEQNVWW6dOWs9mzYr HPqoYF9o1V0ZL/O3BisZd9eoIQrX2rLcUOTZo5QjO 9ii8V 96rSh4jXFG b8vrJcWqbgpTVKRvclR3TVeuXNHpwisK7ztFj89OV33 Lu0pStCU9IHiuxgAgPtPyA9/ MPn6 rqNGHCBGVlZalbfAKTFqCDusqkJSQ0VD1691avHo3K2ZyjpKVPafaYQerZLVohqtLhzS/pJ/9ng3Yd3KajBXHq1 uaPlj7c31Zm6DUAV59/vP/pf/55i59dfK4Tl24rKs3whUXVSN36Ag9umCKoq6e0bHCGD34cD d 2CNfvjCL/TZZ7v05aUm9ewXov1v/Uwff XWqLQknd3wf/Wj7Tf08BPLNWPsMCX17aH6wsM6W95PU6YPU5T9NQMAgPuHUVpaqoKCAuuJuQMAAHScV9WFh/TJxxc1719W68Wf/KP6n81UnjFKzzzziK7v2aVf//odbS7oo//5f/9Vfzz7MT3zF/9d//g3izUwxK3T z7Syz/7qX5xIEc9J6Yprviw3thwTg/81x/qlTV/rb75n2nXKZfmPfsd9SvJ1sfvv63XTni19NtPaWzPKDUW V7/4gt67/MzSnlsknrYXxUAALi/GBcvXtSoUaO0c dOLVy40C63Zu6T3NjYaD9r7V7PgUA4/fwONPfL26z6glPaceyMNv373 sv//4n2l1wUhcue5WYMlvzx0Tok19d0NBVzyi9/21bJluXbEMU3T1RA4cOU99e3eQ5e0YlhWW61CNFyUMiZHRPUtoQj qu1yiy52jNnT1Budu ULeHl mRtDi5fO9hRHbT4KEjNaLPIOV 8ZUqrDfHvcbp5z85OTm5P TBy42JEycqMjJS06ZNs26T8if/7FlteOcd 1lr fn5eucezoFAmH1aNmzYYD9rzenn/51yv7xSsyIUPyBNi579j/rzv/gbPf9P/1tPTu6lphuXlFfQqPie13QhJ1dVdebuHo3yeHwHWbefRmjg6Gmav3SpHpk6UOUnDqq4LlzR10tV UVUvr6dWV683K8Qw1OyuUMH5Uinao4snD6movEZ1dTUyeiXr4bnzNGNcrEpP5uharfm uNc4/fwnJycn94c8eLnrk08 8ebk5CgjI0OrV6/22xGfPi1Aa12tT0tTw0mtefZV9fmH7 upsQkyXF7VVeTonRfWqDTxUU0ZGavyC4Xq dBMNX7 tk65Jmv tFht/ekGhS96Wn0Of6B9zeO1bP4kNeRs0/Yjhh6Yl6prX27VIeMR/e3/M14HfvhjHer2oBYOrdbmXeWa9b0V6nf5M 046dH8J2Yr95WfKr/fDI3s1Sx3 CD1j6xUzsF9qhn/tP7iyUmKvZ8W3nUhTj//ycnJyf0hD04e8swzzzw/ffp0a13L2LFj1eibrfhbiN89Jqzdhfjh4e1vN q0nIX4CNTtC/HvxGnnf0t3yi3eZnkVraTRo9Q3NtT388ClsOgEDRvVR5f37tXxgkty9xyt6aOidfFKoyY89JgmD B2sIUlSXlGTJk3PkLs0X0XXojVyfB/VXLqgC1eK5UkYoW995xml9uqh4alJKjt SCeKPZq8eKkeSu6mwlNn1GPqcs1OGaJBA N0 vxF3w wBF05eUj5RVcV1f8RPfPMdPUwmLHcq5x /pOTt4ecvD3k30zuys7O9sbFxVlXG2pra VuaKZPC9BBXaVPCwAAQGcyzH4HmzdvtmYxb7zxhl0GAAAAAGcwBgwYoJUrV8q82mL CgAAAABOYpi3RpWXl vIkSPtLoIBAAAAgM7g2rZtmzcvL8/aPexnP/uZ393DDHmUENGk8LAwu/J15j7Kzc3N1qLktjgxZ00LAnVrTYvJ3NDBSef37QLNvV6v9RoAAACTOWbweDxBG5 4Tp065Q0NDZX5 Oyzz9Ste682Jy3nz57WmWP79dxzz9mVrzMnPgcOHLinciYtCNStSYvZp2XHjh169tln7eTrnHj 3 5OeWVlpfW9Yv7gAAAAXZu5a qDDz5o7cJrNqgPxvjH9corr3hTU1OVnZ2tESNGqNbt8bt7WGRT1Teyz7I/wc6ZtCBQXaVPy9WrV7V3717V1NSooaHBrgIAgK4oMTFR8 bNs8bOwRr/uHyDdu/p06etHi3r1q1TxtQH2fIY6KCusuXxrUnLuXPnNHToUL5XAADowgYPHqzRo0cHdfzjOnHihPfGjR sydxF7 23NWJUGpMWoIO62qTF/J555plnrIkLAADomjpj/GNkZWVZi2g2btyoMWPG2GUAAAAAcAZj1qxZ1mKaRYsW6cyZM3YZAAAAAJzBKC0tVWFhofXEXKEP AAAAAE5iXLx4USNHjrS2O164cKFdbq2pyaPGxkb7WWvmPsr3cg4Ewunnd6A5AABAS8EcnxgTJ05 UZGSkHnjgAas5nj/5Z/O14Z137Get5efn6517OAcCYfZp2bBhg/2sNaef/3fKAQAAWgrm Mf1ySefeHNzczV58mStXr3ab0d8 rQArXW1Pi3sHgYAADpj/GOYHa4XL16s8vJyPf3003bctph23tDU3ic0OT0HAuH08zvQHAAAoKVgjU Mnj17qr6 3potmfeNAQAAAICTGFeuXNHmzZsVHh6uN9980y4DAAAAgDMY/fv318qVK61LL avAAAAAOAkxuXLl1VRUWEtSL/TPWUAAAAAEGxGRESE9uzZo7S0tHa3HGvyeNTYEJx9mNtyt3MgEE4/vwPNAQAAWgrm MQYOHCg5s frz59 ujhhx 2im0x90m 0z7M93IOBKIj 5TfyzkAAEBLwRz/uF599VVvSkqKsrOzNWLECNW6PfRpATro9n3KS0pKFBMTYyetOe38b6m9nD4tAADgls4Y/xjp6ekqLCzUY489pl27dtlx2 jTAvjX3jesyenn/51yAACAloI1/jHCwsI0ePBgxcXFyezZAgAAAABOYmRlZVkLXDZu3KjRo0fbZQAAAABwBmPmzJkyDEOLFi3SmTNn 7DIAAAAAOINRVlZmrWlxuVzKy8uzywAAAADgDMbFixetXcN27NihhQsX2uXW6NMC Of08zvQHAAAoKVgjk MiRMnKioqStOnT1dlZaVVbMs3uc9yWzo7BwJBnxYAANDVBLVPyyeffOLNzc1VRkaGVq9erSXLnq JPC9BB9GkBAABdTaf0aWlubtbixYtlrm1ZtWqVHbeNPi2Af/RpAQAAXU3Q rSYvVnq6 utT2jeNwYAAAAATmJcuXJFmzdvltlk8s0337TLAAAAAOAMRv/ /bVy5Urr0ov5KwAAAAA4iVFUVKSKigprQTr3tAMAAABwGsO8LWzPnj1KS0vT vXr7XJr9GkB/POY3x8OPr8DzQEAAFoK5vjHGDRokObPn6/ExEQ98sgjVrEtd9pH U77NDs9BwLB9wcAAOhqgjn cb366qvelJQUZWdnW53xa92edvq03FBs7P3Th4I LQgUfVoAAEBX0yl9WtLT03Xx4kXNmTNHu3btsuO2xbQzYTG19wlNTs BQNCnBQAAdDVB69NirmkZMmSIdZXB7NkCAAAAAE5iZGVlWQtcNm7cqNGjR9tlAAAAAHAGY bMmXK5XFq0aJHy8vLsMgAAAAA4g1FWVqbLly9bExdzhT4AAAAAOIlhLsIfPny4duzYoQULFtjl1 ujTAvhHnxYAANDVBLVPy8SJExUZGanp06ersrLSKraFPhSAf3x/AACAriaofVo eQTb25urjIyMrR69WotWfYUfVqADqJPCwAA6Go6pU LednFXIRfWlqqVatW2XHb6NMC EefFgAA0NUErU9L79691dDQYBXMCQwAAAAAOIlRVFSkzZs3y2wy eabb9plAAAAAHAGo3///lq5cqV1acf8FQAAAACcxLrSUlFRoWPHjnFPOwAAAADHMczbwvbs2aPU1FStX7/eLrdGnxbAP/q0AACAriaofVoGDRqk fPnKzExUY8 qhVbAt9KAD/ P4AAABdTVD7tLz66qvelJQUZWdna8SIEap1e37vPi01NTXtbnvmtJw LQjU77JPudPO/5bay nTAgAAbumM8Y Rnp6ugoICzZkzRzt37rTjtt2pT0t7n9Dk9BwIhNPP70BzAACAloI1PrHWtAwbNsy6ymD2bAEAAA AAJzGysrKs5pIbN25UWlqaXQYAAAAAZzBmzpwpl8ulRYsWKS8vzy4DAAAAgDMY5eXlunz5sjVxM XcAAAAAAAAnMczdgIYPH64dO3bo8ccft8ut0acF8I8 LQAAoKsJap WyZMnKzIyUtOnT1dlZaVVbAt9KAD/ P4AAABdTVD7tHzyySfe06dPy5y8rF69WkuWPUWfFqCD6NMCAAC6mk7p02Jedlm4cKH1CVetWmXH baNPC Cf08/vQHMAAICWgjU MczeLOaWx ZVBnMCAwAAAABOYly5ckWbN29WaGio3nrrLbsMAAAAAM5gJCUlacWKFdalF/NXAAAAAHASo7i4WNeuXdPx48cVFxdnlwEAAADAGQzztrDPP/9cKSkpevvtt 1yazf7tDTYz1oz18OYa2P8cXoOBKIj 5Q7 fy/Uw4AANBSMMc/xqBBgzR//nwlJibq0UcftYptsfZhfvdd 1lr5j7K797DORCIjuxT7uTz/045AABAS8Ec/7hee 01b3Jysg4dOmR1xq91e/z3aWm odh2tiX7pvZh9uebzunTgkDRpwUAAHQ1ndKnZfz48SooKLCusuzcudOO29beG5ru9RwIhNPP70B zAACAloI1PjHCw8M1bNgw6yqD2bMFAAAAAJzEyMrKsha4bNy4UaNHj7bLAAAAAOAMxsyZM60PFi 5cqNOnT1sfAwAAAIBTGOXl5TK74psLacwdAAAAAADASQxzNyBzTcv27dv1 OOP2 XW6NMC EefFgAA0NUEtU/L5MmTFRkZqQcffNDavswf rQA/tGnBQAAdDVB7dPyySefeM21LBkZGXrhhRe0ZNlT9GkBOog LQAAoKvplD4t5mUdcxF cXGxVq1aZcdta 8NTfd6DgTC6ed3oDkAAEBLwRqfGImJida9YuZVBvO MQAAAABwEsPcOWzz5s0KDQ3VW2 9ZZcBAAAAwBmMpKQkrVixwrovzfwVAAAAAJzEMBfPXLt2TSdOnFBcXJxdBgAAAABnMMxV/7t371ZKSkq7t4fRpwXwjz4tAACgqwlqn5ZBgwZZTSXNBflz5syxim2hTwvgH31aAABAVxPUPi2v vfaaNzk5WYcOHdLw4cNV6/bQpwXoIPq0AACArqZT rSMHz/eGog88sgj uyzz y4be29oelez4FAOP38DjQHAABoKVjjEyMiIsK6whIfH68 ffpYRQAAAABwCuPgwYPWApeNGzcqLS3NLgMAAACAM7hOnz7tNe9FMxfif/zxxxo8dKTfNS09o5rlsp/fD26tafF6vVq2bJmioqLsBOiY6upqay2UeU n fH96taaFvO 0vnz56tv3752AgAAuprOGP 49u/f7zUXoqenp vHP/6xZj8yt8tMWm7cuKHy8nKZDTaZsOD3detey/t50lJfX6/Lly rd /ebFgBAACCPv5xrV /3jty5Ehr97ABAwbI3dDc5qTF8HqUEOFReHi4Xfk6cx9l83Ev5ebHkZGR1sdm1tzcrLCwMOt5S Tk7eXmLZbmJLi9481HMM/v2wWam8zvlfaOd/J/H3JycnJy8raQB5YHc/wT8i//8i/PG4ahgQMHqqCgQKFhEUoaOFTNXvvVtnP5Z7R7x1ZNGD/ernzdmTNntG3bNpm7kbXFibn5H8FsiGP gZ86dUofffSRUlNTrectH Tkd8q3bNniqPP7doHmeXl51u2jTv7zJycnJycnJw9 Hqzxj2v79u3e3NxcZWRk6IUXXtCSZU91mT4tLZGTk5P7Q05OTu4POTn53c9dmZmZVnPJ48ePW5d 22msueb taQEAAADgfIbZm8W8Rap79 7WPWMAAAAA4CRGUVGRNm/ebG1Z9tZbb9llAAAAAHAGw y3sGLFCkVHR2vlypV2GQAAAACcwSgtLdW1a9d08uRJxcbG2mUAAAAAcAbD3O549 7dMhfjt3d7WJPHo8aGBvtZa Z6GHPrM3/IycnJ/SEnJyf3h5ycnNxkDB48WAsWLFBiYqLmzJljFduSn5 vDe az9r7ezZs3qX3H7WGjk5Obk/5OTk5P6Qk5PfzF2vvfaaNyUlRdnZ2Ro fHi7Wx5HNd9wxD7N/pCTk5P7Q05OTu4POTm583PXoUOHrOaSZqfJ119/XdOmz6JPCwAAAADHMCIjIzVy5EjFx8fL7NkCAAAAAE5iHDx4UPX19dq4caPS0tLsMgAAAAA4gzF z5kzrg4ULF8q8TQwAAAAAnMSoqKhQcXGx1RH//PnzdhkAAAAAnMEwJypDhgzR9u3bNX/ fLvcGn1ayMnJ/SEnJyf3h5ycnNyf3yU3Jk erKioKM2YMUPXr1 3im2hTws5Obk/5OTk5P6Qk5OT /O75K7t27d7T58 LXPy8sILL2jJsqfo0 IHOTk5uT/k5OTk/pCTkweeuzZv3mw1lzx27JjCw8PbbS5JnxYAAAAAwWb07dtXjY2NSkhIsO4bAwAAAAAnMYqKirR5 82Zr97C33nrLLgMAAACAM1hXWlasWGEtxl 5cqVdBgAAAABnMMrKyqxdw06dOqXY2Fi7DAAAAADOYLhcLu3atUsjR45s9/Yws09Le/soe8jJye1nrZGTk5P7Q05OTu4P W9zY9CgQVqwYIH69OmjOXPmWMW2mH1a3mtnH2Uzb2 fZXJycnJ/yMnJyf0hJycnN7lef/11b3JysrKzszV8 PB2tzymTws5Obk/5OTk5P6Qk5OT 9PR3HXo0CFvbm6uxo8fr9dee00PPPgQfVoAAAAAOIYRGRlprWeJj4 XuZMYAAAAADiJcfDgQdXX12vjxo1KS0uzywAAAADgDMaMGTPk9Xq1cOFCmbeJAQAAAICTGNeuXV NpaalCQ0N14cIFuwwAAAAAzmCcO3dOgwcP1rZt2zRv3jy73Bp9WsjJyf0hJycn94ecnJzcn98lN yZPnqyoqCjNnDlT5lUXf8x9kunTQu4POTk5uT/k5OTk/pCTdzR3bd 3Xv69GmZk5fVq1dr8dIn6dPiBzk5Obk/5OTk5P6Qk5MHnrs2b97sTUlJ0bFjxxQeHt5uc0n6tAAAAAAINsPszdLY2KiEhAQ1NTXZZQAAAAB wBqOoqEibN29WSEiI3nrrLbsMAAAAAM5gXWlZsWKFtRh/5cqVdhkAAAAAnMEoLy/X9evXlZOTo9jYWLsMAAAAAM5gmP/atWuXRowYoTfffNMqtoU LeTk5P6Qk5OT 0NOTk7uz SG4MGDdKCBQuUmJiouXPnWsW2mPsk06eF3B9ycnJyf8jJycn9ISfvaO56/fXXvcnJycrOztbw4cPb3fI4qrlaMTHRdqW12tpaRUeT 0NOTk7uDzk5Obk/5OTk0XL5Jive3NxcjR8/Xq 99pqmz5hNnxYAAAAAjmGYu4aZV1q6d ufv362WUAAAAAcAbj4MGDcrvd2rhxo1JTU 0yAAAAADiDMWPGDHm9Xi1cuNDa9hgAAAAAnMS4du2aysrKFBoaqosXL9plAAAAAHAG49y5cxo4c KC2bdvW7pbH9GkhJyf3h5ycnNwfcnJycn86nkv/P5K5KU21TXXvAAAAAElFTkSuQmCC



Private Sub CommandButton2_Click()


UserForm1.Show


Dim tbl As ListObject
Dim rng As Range
Set tbl = ActiveSheet.ListObjects("Table6")
Set rng = tbl.ListColumns(1).DataBodyRange


Dim cl As Range
For Each cl In rng
UserForm1.ListBox1.AddItem (cl.Value)
Next
End Sub



Any help you could provide on this would be extremely helpful.


Many thanks in advance.

Paul_Hossler
09-27-2023, 05:35 PM
Attach a small workbookwith some data, the userform and your macros

ecalid
09-28-2023, 04:11 AM
Thanks Paul_Hossler

Please see attached

Dave
10-02-2023, 08:28 PM
Hi ecalid. Not much luck with this one. This seems to work. HTH. Dave
Userform1 code...

Private Sub ListBox1_Click()
Dim tbl As ListObject
Set tbl = Sheets("Briefing").ListObjects("Table6")
'column D
UserForm1.TextBox4.Text = _
Intersect(tbl.ListRows(UserForm1.ListBox1.ListIndex + 1).Range, tbl.ListColumns(3).Range).Value
'column G
UserForm1.TextBox1.Text = _
Intersect(tbl.ListRows(UserForm1.ListBox1.ListIndex + 1).Range, tbl.ListColumns(5).Range).Value
'column E
UserForm1.TextBox3.Text = _
Intersect(tbl.ListRows(UserForm1.ListBox1.ListIndex + 1).Range, tbl.ListColumns(4).Range).Value
'column I
UserForm1.TextBox2.Text = _
Intersect(tbl.ListRows(UserForm1.ListBox1.ListIndex + 1).Range, tbl.ListColumns(8).Range).Value
'column J
UserForm1.TextBox5.Text = _
Intersect(tbl.ListRows(UserForm1.ListBox1.ListIndex + 1).Range, tbl.ListColumns(9).Range).Value
End Sub