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