View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default combo box beginner question...

for completeness - as Norman Jones pointed out, the AddItems need to be
..AddItems with a period to show they are qualified by Me.Internet

Private Sub Userform_Initialize()
With Me.Internet
.AddItem "A"
.AddItem "B"
End With
End Sub

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
You will see very few answers from Microsoft Employees. These are

primarily
peer to peer support. Those MS employees that do answer indicate they

are
employees with something like

Buddy Rich [MSFT]

or
Buddy Rich [MS]

or something similar.

So, no I am not a microsoft employee.

--
Regards,
Tom Ogilvy

"thomas" wrote in message
...
That's a big help for me. I notice you answer a lot of people's

questions,
do
you work for Microsoft...No need to answer if to busy.
Thanks for the help

"Tom Ogilvy" wrote:

Private Sub Userform_Initialize()
With Me.Internet
AddItem "A"
AddItem "B"
End With
End Sub

If internet is the name of the combobox, it isn't going to change

unless
you
type something in it or you make a selection - I doubt that is what

you
want, so put your code in the Initialize event of the Userform. This

should
be in the userform module( select the events from the dropdowns at the

top
of the module to make sure they are declared correctly).

--
Regards,
Tom Ogilvy


"thomas" wrote in message
...
I've tried to find how to make choices in a combo box but had no

luck.
This
is the code I wrote, but it doesn't show up in the combo box:


Private Sub Internet_Change()
With Internet
AddItem "A"
AddItem "B"
End With
End Sub


Why doesn't this show up when form is ran???
Thanks ahead of time,
Tom