combobox1_click was public but on a different sheet than th
selectionchange, but the code switches to the sheet containin
combobox1 before i try to call the procedure so even that shouldnt mak
a difference. for some reason it still didnt work, and there must b
something wrong with my code because selectionchange isnt firing when
select the given cell, in this case CA

--
Message posted from http://www.ExcelForum.com