Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add item to comboBox "form" from vba
Hi! how can I add 2 items say "QAZ" and "WSX" to a ComboBox inserted in th activesheet using the forms toollbar from VBA Sub help() with activesheet.combobox1 .additem "QAZ" .additem "WSX" end with 'this work when the combobox comes from the activecontrols toolbars bu when 'from the other toolbar? ens sub many thanks -- 0000_AAAA_000 ----------------------------------------------------------------------- 0000_AAAA_0000's Profile: http://www.excelforum.com/member.php...fo&userid=1248 View this thread: http://www.excelforum.com/showthread.php?threadid=27407 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add item to comboBox "form" from vba
Sub help()
with activesheet.DropDowns(1) .additem "QAZ" .additem "WSX" end with end sub Replace the 1 with the name of the dropdown (found in the name box when the control is selected) if you wish. -- Regards, Tom Ogilvy "0000_AAAA_0000" wrote in message ... Hi! how can I add 2 items say "QAZ" and "WSX" to a ComboBox inserted in the activesheet using the forms toollbar from VBA Sub help() with activesheet.combobox1 additem "QAZ" additem "WSX" end with 'this work when the combobox comes from the activecontrols toolbars but when 'from the other toolbar? ens sub many thanks! -- 0000_AAAA_0000 ------------------------------------------------------------------------ 0000_AAAA_0000's Profile: http://www.excelforum.com/member.php...o&userid=12480 View this thread: http://www.excelforum.com/showthread...hreadid=274076 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop-down list on simple excel 2003 form using "form" from data me | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
any formula to convert numbers in word form, e.g. "2" as "Two"? | Excel Worksheet Functions | |||
function to return day in the form "Monday", "Tuesday" etc given . | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions |