It th erefedit control is on a userform, then you should
click the right edge -there's what looks like a drop-
down - after which you can navigate to any area on any
sheet.

I don't know what you mean by "formular" - I guess you
mean userform.

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
Hello,

I have a formular with a RefEdit element on it.
When I activate the RefEdit on the form I can't
switch to other sheets to select a cell or range?!?
Even on the actual sheet it's not possible to scroll.
I tried so far to set the showModal option and the
screenupdate option of the formular. With showmodal
sometime it works properly but just one time and than
it turns out to get crazy again.

I work with WinXP and Excel 2002!

Hope somebody can help me!!

Best Regards,
daMike


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

.