Hello,

My refedit control should release focus (by a refedit_exit event) in
order to enable populating a listbox after the range on the refedit
has been updated

The problem is that after updating the refedit range, the refedit
retains focus. I tried change_event, but it prevents the updating the
refedit .

Any idea?

Thanks a lot
Avi

It would help to answer this if you could give us some context by including
the code snippet that makes use of the refedit.
Have you tried including a line in your refedit_exit event code to either
pass the focus to another control or to select a cell reference? Eg:
UserForm1.ListBox1.SetFocus

"avi" wrote:

Hello,

My refedit control should release focus (by a refedit_exit event) in
order to enable populating a listbox after the range on the refedit
has been updated

The problem is that after updating the refedit range, the refedit
retains focus. I tried change_event, but it prevents the updating the
refedit .

Any idea?

Thanks a lot
Avi