Workbook changes, Lock Combobox

**burugudug** · 03-11-2010, 03:27 AM

Why does my workbook changes in the middle of the process?
although i set the name of the workbook?
im getting the values from a different workbook, but the value being displayed is from the main workbook where the GUI is created.

and how do i lock the combobox so that the it will prevent the user to type any text. --- got the answer to this

only need to know why the workbook changes in the middle of the process
and with that, different value is displayed in the GUI

looking forward to your help,
thanks in advance

**burugudug** · 03-11-2010, 04:34 AM

other than it returns to the main workbook
the the value of the cell changes
for example:
from cells(6,2) it will be like cells(2,2)
with that it will return the value in celss(2,2) of the main workbook
and not the value in cellS(6,2) of the targeted workbook.

really need to solve this one
thanks