Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Given a simple form with one listbox, I have loaded the code as follows:
Private Sub UserForm_Initialize() ListBox1.RowSource = "A1:A26" End Sub Private Sub ListBox1_Click() ListBox1.RowSource = "" ListBox1.RowSource = "A9:A14" End Sub where A1 .. A26 are the letters of the alphabet. Question 1: Putting a break in Listbox1_Click() shows that when I click on the listbox, ListBox1_Click() fires two times. Why is that so? Question 2: When I click on the listbox, why aren't the contents of the listbox changed to reflect the new rowsource? Thanks for any help! -Tim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Listbox rowsource on Userform | Excel Discussion (Misc queries) | |||
RowSource in ListBox | Excel Programming | |||
ListBox Rowsource Limitation?? | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
listbox rowsource | Excel Programming |