Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically update Value for data label | Charts and Charting in Excel | |||
MyArray (ComboBox.ListCount-1) possible? | Excel Programming | |||
Is it possible to Link a Label control to a cell ? | Excel Worksheet Functions | |||
Link Cell to Label Caption | Excel Discussion (Misc queries) | |||
Link cell to Label Caption | Excel Programming |