excel - VBA ComboBox not displaying values -


this question has answer here:

trying use comobobox vba , displays 1 empty row when click on down arrow. have never used combobox before , still beginner vba.

private sub comboboxt_change()      comboboxt.additem "apple"      comboboxt.additem "orange"      comboboxt.additem "banana" end sub

like saagar said, way code written, add items combobox if there change in combobox. code use this:

private sub userformname_activate()    comboboxt.additem "apple"    comboboxt.additem "orange"    comboboxt.additem "banana" end sub

the easiest way achieve in user form creator, double click on userform frame. should show code working with, top dropdown bars (the first 1 might either "userform" or "general") can select "userform" in first 1 , "activate" in second one. should give place start, , items wanted added combobox should right there, ready go. hope helps :)


Comments

Post a Comment

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

i make custom datepicker directive custom template. but have no idea how start building it... how include date data directive? i appreciate guide or give me advice work on more precisely. it might you! follow below steps html code sample: <label>birth date</label> <input type="text" ng-model="birthdate" date-options="dateoptions" custom-datepicker/> <hr/> <pre>birthdate = {{birthdate}}</pre> <script type="text/ng-template" id="custom-datepicker.html"> <div class="enhanced-datepicker"> <div class="proxied-field-wrap"> <input type="text" ui-date-format="yy-mm-dd" ng-model="ngmodel" ui-date="dateoptions"/> </div> <label> <button class="btn" type="button"><i class="icon-calendar"></i>
Read more

javascript - jQuery date picker - Disable dates after the selection from the first date picker -

<!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <title>jquery ui datepicker - default functionality</title> <link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css"> <script src="//code.jquery.com/jquery-1.10.2.js"></script> <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script> <link rel="stylesheet" href="/resources/demos/style.css"> <script> $(function () { $("#datepicker1").datepicker(); }); </script> <script> $(function () { $("#datepicker2").datepicker(); }); </script> </head> <body> <p>date 1: <input type="text" id="datepicker1"></p> <p>date 2: <input type="t
Read more