Refedit retains focus
 

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

Refedit retains focus
 

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