Thread: excel combobox
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bagpuss Bagpuss is offline
external usenet poster
 
Posts: 2
Default excel combobox

How can I use a combobox to select 1 row with 5 colums data from a seperate
worksheet containing over 100 rows of data and populate 5 cells on current
sheet? Ideally would like to detect number of rows of data automatically to
cope with different lists