Thread: Listbox
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Listbox

Hi Benjamin

You choose value #3 from the top like this:

ListBox1.Listindex = 2

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Ben.c" wrote in message
...
Hi,
I have a userform with 2 listbox from whicht the user can choose the start date and the

end date.
I put at the activation of the userform in each listbox a series of dates. I would like

than when the user choose a date for the start date, the date possible for the end date
start by this one. And If the user put in first the end date, I would like than the date
available for start date end with this one. My problem is that I don't know how to choose
an item from my listbox.
Can you help me ?
Thanks and happy new year
Benjamin