Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox Initial Values
I have two listbox controls named FROM and TO
The rowsource for both is the same, but variable in length. When the user form loads, I would like to have FROM display and select the first value in the rowsource, and to have TO display and select the last value in the rowsource. Using TOPINDEX causes the correct value to be displayed, but the returned value is null. Any suggestions please? Thanks. Marvin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox Initial Values
If you have only one column in the ListBox and the BoundColumn is set to 1,
then you can use the Value property to return the displayed value. x = UserForm1.ListBox1.Value MsgBox x Would display the selected value. Also see the Selected property in VBA help. "Marvin Buzz" wrote: I have two listbox controls named FROM and TO The rowsource for both is the same, but variable in length. When the user form loads, I would like to have FROM display and select the first value in the rowsource, and to have TO display and select the last value in the rowsource. Using TOPINDEX causes the correct value to be displayed, but the returned value is null. Any suggestions please? Thanks. Marvin |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox Initial Values
To return the last item in the list box.
y = UserForm1.ListBox1.Selected(ListBox1.Rows.Count -1) MsgBox y ListBox row index begins with zero, so the last item index number will be one less that the number of rows. "Marvin Buzz" wrote: I have two listbox controls named FROM and TO The rowsource for both is the same, but variable in length. When the user form loads, I would like to have FROM display and select the first value in the rowsource, and to have TO display and select the last value in the rowsource. Using TOPINDEX causes the correct value to be displayed, but the returned value is null. Any suggestions please? Thanks. Marvin |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox Initial Values
Maybe my requirement wasn't clear. I want the FROM box to display the first
item from rowsource, and the TO box to display the last. Additionally, the values to be returned from the controls must be the first and last respectively. Marvin "JLGWhiz" wrote: To return the last item in the list box. y = UserForm1.ListBox1.Selected(ListBox1.Rows.Count -1) MsgBox y ListBox row index begins with zero, so the last item index number will be one less that the number of rows. "Marvin Buzz" wrote: I have two listbox controls named FROM and TO The rowsource for both is the same, but variable in length. When the user form loads, I would like to have FROM display and select the first value in the rowsource, and to have TO display and select the last value in the rowsource. Using TOPINDEX causes the correct value to be displayed, but the returned value is null. Any suggestions please? Thanks. Marvin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box initial values question | Excel Discussion (Misc queries) | |||
Combo Box initial values question | Excel Programming | |||
What gets XNPV to calculate correctly if initial values are zero? | Excel Worksheet Functions | |||
Fill values into a listbox matching selected values from a combobox | Excel Programming | |||
Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming |