Prev: add years to a cell
Next: view list of named ranges
From: Edu on 3 Mar 2010 15:36
Does this solution add the new text to the drop down menu? so that next time
you use the combobox that value will be present?

"HFB" wrote:

> BEAUTIFUL! Thanks heaps Tom :)
>
> "Tom Ogilvy" wrote:
>
> > Private Sub Combobox1_Click()
> > if Combobox1.Value = "Other" then
> > res = Inputbox("enter special selection")
> > if res <> "" then
> > combobox1.Value = res
> > End if
> > End if
> > End Sub
> >
> > Make sure the style of the combobox is fmStyleDropDownCombo
> > This is the default, so if you haven't changed it you should be OK.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "HFB" <HFB(a)discussions.microsoft.com> wrote in message
> > news:CA2A052F-0195-46D0-AAF9-D8F83857C0AA(a)microsoft.com...
> > > yes
> > >
> > > "Chip" wrote:
> > >
> > > > do you know how to make a userform?
> > > >
> > > >
> >
> >
> >
 | 
Pages: 1
Prev: add years to a cell
Next: view list of named ranges