Using VBA and Selenium to Select an item from a drop down list

Hey guys,

I ran into another problem with a program I am working on, and was wondering if some one would be able to assist me, with drop down lists.

I would like to select the following element, and choose one of the items in the list.

 <select class="form-control" data-val="true" data-val-number="The field Tenant must be a number." data-val-required="The Tenant field is required." id="TenantId" name="TenantId" onchange="getTenantUnitsByTenant(this)"><option>Select...</option><option value="30259"> 6TH SENSE CAFE</option><option value="30285"> 6TH SENSE CAFE</option><option value="30252"> A &amp; W</option><option value="30256"> A &amp; W</option><option value="30297"> ALBERTA SUPPORTS CENTRE</option><option value="30298"> ALBERTA SUPPORTS CENTRE</option><option value="30289"> AMBA JEWELLERS</option><option value="30226"> ARDENE</option><option value="30265"> BELL</option><option value="30223"> BO' DIDDLY'S PUB &amp; GRILL</option><option value="30243"> Canadian Tire</option><option value="30229"> Carat Jewellers</option><option value="30284"> CELLICON</option><option value="30270"> Cellular Stylez</option><option value="30287"> CHATR</option><option value="30225"> CLAIRE'S</option><option value="30244"> CO-OP</option><option value="30217"> COLES</option><option value="30274"> CREW BARBERSHOP</option><option value="30300"> CURRIES &amp; PUFFS</option><option value="30224"> DOLLARAMA</option><option value="30273"> Dragon FX</option><option value="30286"> EASTERN ARTS</option><option value="30257"> EDO JAPAN</option><option value="30247"> EDO JAPAN</option><option value="30232"> Escada Hair International</option><option value="30239"> Famous Wok</option><option value="30291"> Famous Wok</option><option value="30307"> FANTASY GOLDSMITH</option><option value="30216"> FIDO</option><option value="30214"> FLIGHT CENTRE</option><option value="30283"> FRANCIS DAUK</option><option value="30263"> FREEDOM MOBILE</option><option value="30237"> Game City</option><option value="30266"> GoodLife Fitness Club</option><option value="30264"> Hakim Optical</option><option value="30241"> HIMALAYAN VILLAGE</option><option value="30253"> INTERNATIONAL NEWS</option><option value="30262"> Jay Set</option><option value="30288"> KIDDIE CORNER &amp; YASMIN HOUSE OF ISLAMIC</option><option value="30279"> KOODO</option><option value="30261"> KOODO</option><option value="30280"> LENSCRAFTERS</option><option value="30215"> Luckylott</option><option value="30250"> M&amp;M FOOD MARKET</option><option value="30260"> Mad Hatter's Superstore</option><option value="30296"> MADURAI VILLAS</option><option value="30306"> MADURAI VILLAS</option><option value="30245"> MILANO CLUB</option><option value="30254"> MILL WOODS TAILORS</option><option value="30272"> Mill Woods Town Centre Dental Clinic</option><option value="30242"> MILLANO BAGS &amp; BAGGAGE</option><option value="30231"> MORNING SUN HEALTH FOODS</option><option value="30249"> Murray's Hairstyling</option><option value="30308"> NATIVE SPIRIT</option><option value="30221"> NEW YORK FRIES</option><option value="30248"> ORANGE JULIUS</option><option value="30277"> ORANGE JULIUS</option><option value="30251"> Paris Jewellers</option><option value="30230"> Play Pen Pets</option><option value="30290"> Q NAILS</option><option value="30294"> REVOLVER</option><option value="30269"> RioCan Property Services</option><option value="30219"> ROGERS</option><option value="30301"> ROGERS BROASTER CHICKEN</option><option value="30303"> ROGERS BROASTER CHICKEN</option><option value="30295"> SCRUB CITY UNIFORMS</option><option value="30228"> SHOE WAREHOUSE</option><option value="30246"> SHOPPERS DRUG MART</option><option value="30240"> SHOWCASE</option><option value="30227"> Smitty's</option><option value="30220"> Studio Nails</option><option value="30278"> SUBWAY</option><option value="30281"> SUBWAY</option><option value="30267"> SUNG LEE TAEKWONDO</option><option value="30234"> TACO TIME</option><option value="30236"> TELUS</option><option value="30282"> THE BANK OF NOVA SCOTIA</option><option value="30238"> THE BANK OF NOVA SCOTIA</option><option value="30293"> THE SOURCE</option><option value="30271"> THINGS ENGRAVED</option><option value="30276"> TIM HORTONS</option><option value="30299"> TIM HORTONS</option><option value="30222"> TIME CHECKER</option><option value="30268"> TUTTI FRUTTI FROZEN YOGURT</option><option value="30305"> URBAN BROW</option><option value="30304"> V M SOLUTIONS INC.</option><option value="30523"> V M SOLUTIONS INC.</option><option value="30255"> Virgin Mobile</option><option value="30233"> Virgin Mobile</option><option value="30302"> Vitality Health Foods</option><option value="30235"> WARP III</option><option value="30258"> WIRELESSWAVE</option><option value="30218"> WIRELESSWAVE</option><option value="30275"> WOW! MOBILE BOUTIQUE</option><option value="30525"> WOW! MOBILE BOUTIQUE</option><option value="30292"> YELLOW, PRESTIGE, CHECKER, BARREL</option><option value="-100"> RioCan Common Area</option><option value="-99"> Vacant</option></select> 

My code so far for this looks like the following:

bot.FindElementByClass ("col-lg-2") bot.FindElementByClass("form- control").AsSelect.SelectByText ("Canadian Tire") bot.SendKeys Keys.Enter 

If I am doing something wrong please let me know.

Submitted August 22, 2019 at 10:41PM by dragonchicken https://ift.tt/2Zk0mZ4