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

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"avi" wrote in message
ups.com...
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

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.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"avi" wrote:

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

Thanks a lot

As usual, I end up with using input box

Avi