View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ray Kanner[_2_] Ray Kanner[_2_] is offline
external usenet poster
 
Posts: 14
Default Creating a List Box on the fly

I have a start date and and an end date as ranges in a
worksheet and would like the user to input a date in
between the start end and dates, with the only allowable
dates being the first of each month. Can I create a list
box that would have the permissible dates and have the
user choose one? Is this doable on the fly, since the
start and end dates frequently change? Would someone have
some sample code?

Thanks in advance

Ray Kanner