hello everyone,
I am having combobox in worksheet.
when the value in combobox is selected, it simultaneously triggers the change event which will change the value of some cells in worksheet.
I have the following code in combobox change event.
the above code works fine...![]()
Please Login or Register to view this content.
but when any other workbook is open..parallely ... it GIVES "RUN TIME ERROR-9" "SCRIPT OUT OF RANGE"
DON'T KNOW WHAT TO DO.. TRIED VARIOUS OPTIONS... BUT NOT GETTING ANY WAY OUT THIS..
ANY HELP WILL BE APPRECIATED.
THANK YOU IN ADVANCE
Bookmarks