listbox items not displayed

[VBABEGINER]

Hi Experts,
Good Evening.

There is one simple i am not able to solve.

I used one listbox, added the items in that, i put this code on sub worksheet_activate.

But this items are displyed when open a sheet. every time i go to code click in this "Sub Worksheet_Activate()" code - doing "alt f11" and then only this items listed in the listbox.

Is there any permanant solution for this, Experts?

Private Sub Worksheet_Activate()
ListBox1.Clear
ListBox1.AddItem "Name"
ListBox1.AddItem "Name2"
End sub

 

[CharlesChuckieCharles]

Seems to work okay.... did you use a form listbox or an activex listbox?

 

[VBABEGINER]

Seems to work okay.... did you use a form listbox or an activex listbox?

--
Hello Sir,

No i have used listbox from toolbox of our visual basic.

 

[VBABEGINER]

--
Hello Sir,

No i have used listbox from toolbox of our visual basic.

***********
Can anyone solve this problem?

 

[CharlesChuckieCharles]

Can you use an activex listbox which you will find available on the developer tab?