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

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -