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,
daMik

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

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/

.

I use that "dropdown" and that feature cause the problem.
When I activate the "dropdown" I can't select a cell or range
on other sheets and it's even not possible to scroll on the
active sheet. "formular" meant "userform", sorry for that!

Hope you can help me!

Best Regards,
Michael

"Patrick Molloy" wrote in message ...
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/

.

A RefEdit control can be used only when a userform is shown 'modal'.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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/