VB Code For ComboBox's
Posted by Damien on June 21, 2001 11:44 PM
I need to know how to add an item to a combobox list form an input box or the like with a macro ie vb code
Any One?
Posted by Malc on June 22, 2001 1:13 AM
Sub Additem()
Userform1.combobox1.additem "New Item"
end sub
Posted by Damien on June 22, 2001 4:03 AM
thanks Malc thats not it but i got it to work anyway cheers
Posted by Tuc on June 22, 2001 6:41 AM
How about:
Dim strHolder as string
Dim strholder As String
strholder = InputBox("Your Prompt Here", "Your Title Here", "Your Default Value Here")
if strholder <> "" then
' If they choose Cancel the return value is an empty string. We don't want to add an empty string to the list, do we?
ComboBox1.Additem strholder
End If
Tuc
