how to disable listbox change event
 

Use the click event instead.

--
Regards,
Tom Ogilvy

"miao jie" wrote in message
...
now I have a program in Excel
sub UserForm_Activate()
** listBox1.clear -- I wanna stop jump to listbox1_change here, how
to do it??
open DBconnection
listBox1.addItem rs.field(1)
......
close DBconnection
end sub

when listbox1's value change, I need use this value to reset listbox2
sub ListBox1__Change()
open dbconn

get some records from DB use listbox1.value
listbox2.clear
listbox2.additem....
.......

close dbconn
end sub

right now, if the grogram run to ** listBox1.clear , then will jump to
ListBox1__Change(), so the dbconnect have no change to close it. if I wanna
reopen this dbconnection, the errer is occured

How to deal with this situation, thanks a lot of !!!!

Miao jie