View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe[_46_] Joe[_46_] is offline
external usenet poster
 
Posts: 48
Default Link the ListCount to a Label automatically.

Happy New Year to all....

I have a listbox(Listbox1) and a label (Label1).

I want to display the count in the label as in code..
Label1.caption = "List Count : " & Listbox1.ListCount

But I am adding and deleting the contents in different places in the
code.
Can there be way to Link that deynamically so that whenever the
ListCount is changed, the Label1 will get updated.

I even tried to put that code in the Sub Listbox1_Change()
But its not conclusive. Some operations it will be Updated, but
sometimes Not.

I also tried the event - Sub ListBin_AfterUpdate(), but thats the same
situation.

Can anyone help?


Thanks & Regards
Joe