View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John C.[_4_] John C.[_4_] is offline
external usenet poster
 
Posts: 5
Default Dropdown Rowsource

I have a list of items on Sheet1 that provide a dialog
dropdown with input values for selection.

I call this dialog while Sheet2 is active. The dropdown
looks in the cells referenced in 'rowsource' on the active
sheet, not sheet1 as desired.

Any way of specifying the sheet and range in the dropdown
rowsource property?