View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Linking Comboboxes

Don't use the rowsource for combobox2
Use the click event of combobox1 to loop through the data and use additem to
add the ticket numbers that match the data selected.


You can put a scroll bar on the userform and write code to scroll down
column A.

--
Regards,
Tom Ogilvy

"Oreg " wrote in message
...
Hello,


Got a combobox question. Ive created a form listing dates (combobox1),
and ticket numbers (combobox2) on a sheet. I've set the rowsource for
both comboxes and info shows up just fine when form is opened. Is
there code I can add that when a date is selected in combobox1,
combobox2 will change to the related ticket number? Also, could a
scroll bar be added which when pulled down, will scroll down column A??


---
Message posted from http://www.ExcelForum.com/