Thread: Open Sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Howard Howard is offline
external usenet poster
 
Posts: 40
Default Open Sheet

Excel 2000
I want the user to click on a down arrow in a cell and open a second sheet.
Then the total from a cell in the second sheet would populate the cell in the
first sheet with the down arrow. I added a combo box to the first sheet and
used the "Linked Cell" and "ListFillRange" properties. That works, but how do
I open the second sheet by clicking on the down arrow?

Thanks,

Howard