View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wazooli Wazooli is offline
external usenet poster
 
Posts: 51
Default making drop downs "volatile"

I have a sheet that contains drop down combo boxes that reference cells on a
separate sheet that contain filenames. I can click on an entry in the combo
box, and the file is automatically opened. The problem is that whatever
filename is displayed in the combo box before I click does nothing, until I
click another, close the file, then go back to the original. I am assuming I
need a volatile call, but I am unsure how to implement this. Any help is
appreciated.

wazooli

P.S. The combo boxes are Active X components, not made via the 'forms'
toolbar.