Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CELL("filename") acting Volatile? (in assoc. with PULL) | Excel Worksheet Functions | |||
How can I get "=TODAY()" results to be non-volatile? | Excel Worksheet Functions | |||
=CELL("filename") VOLATILE? | Excel Worksheet Functions | |||
Making "examp le" become "examp_le" in a string | Excel Programming | |||
VBA: "Volatile" use of concatenated worksheetfunction expression | Excel Programming |