Refedit retains focus (Repost)

[avi]

Hello,

I'm using a refedit whose value (a range address) serves to populate a
listview box.

Is there a way to cause the refedit to loose automatically focus after
it is completely updated, whithout using the change event which seems
to be fired several time as the refedit value is filled, and thus
causing indesirable results

Sorry for reposting but I really need some help

Thanks
Avi

 

[Jon Peltier]

I've found the RefEdit events unreliable. Why not use ListBox1.SetFocus to
take away focus from the RefEdit?

- Jon

 

[John Bundy]

Refedit will let you select multiple ranges and change selections, there is
no way for the system to know when you are done, you have to tell it you are
done with a tab or something to move to the next. Its best try at knowing
when your done is well represented in what you saw with the change event.

 

[avi]

Thanks a lot

As usual, I end up with using input box

Avi