Hello,
I have made a user form with several listbox and I try to access to the text selected in each listbox.
First, I create the following array :
Then, I create the list of possible value of each listbox:
I select a value for each list:
I have also try the property "Value" for listboxes.
And when I look at the value of listBox in the spywindow, I can see the value "" (empty) for some ListBox, not all.
I have more ListBox than 3 ( I have 7 ) but I did not want to make my post too long.
could you help me please ?
Thanks in advance
Matthieu
a french developper
I have made a user form with several listbox and I try to access to the text selected in each listbox.
First, I create the following array :
Code:
TAB_ouiNon(0) = "oui"
TAB_ouiNon(1) = "non"
TAB_Format(0) = "A"
TAB_Format(1) = "AN"
TAB_Format(2) = "N"
Then, I create the list of possible value of each listbox:
Code:
LST_Modif.List = TAB_ouiNon
LST_Fiabilite.List = TAB_ouiNon
LST_Format.List = TAB_Format
I select a value for each list:
Code:
LST_Modif.Text = LST_Modif.list(0)
LST_Fiabilite.Text = LST_Fiabilite.list(0)
LST_Format.Text = LST_Format.list(0)
And when I look at the value of listBox in the spywindow, I can see the value "" (empty) for some ListBox, not all.
I have more ListBox than 3 ( I have 7 ) but I did not want to make my post too long.
could you help me please ?
Thanks in advance
Matthieu
a french developper