I am having intermittent problems with Refedit.

I have a dialog box which has a refedit contained in a Tabstrip. I
have some code that checks the refedit box values every time the
tabstrip changes, ie the user has moved to the next part of the
process.

Normally what happens is the the dialog disappears and when I go into
VBA it sometimes says its still running but it never kills the process
properly.

If you run the process again it kills the old version properly but the
kills Excel.

Any ideas?

refedit cannot be used with MODELESS userforms

it will crash/hang your app. it's a known "quirk"
and mentioned in refedit documentation.

http://msdn.microsoft.com/library/en...objrefedit.asp



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


wrote :

I am having intermittent problems with Refedit.

I have a dialog box which has a refedit contained in a Tabstrip. I
have some code that checks the refedit box values every time the
tabstrip changes, ie the user has moved to the next part of the
process.

Normally what happens is the the dialog disappears and when I go into
VBA it sometimes says its still running but it never kills the process
properly.

If you run the process again it kills the old version properly but the
kills Excel.

Any ideas?

It is modal. Showmodal is set to TRUE

(Presspley) wrote in message . com...
It is modal. Showmodal is set to TRUE

Is there an alternative method to sourcing a range from the spreadsheet?

Use application.inputbox.

dim myRng as range
set myrng = nothing
on error resume next
set myrng = application.inputbox(prompt:="hi there!",type:=8)
on error goto 0

if myrng is nothing then
'user hit cancel
else
'you have a range
end if



Presspley wrote:

(Presspley) wrote in message . com...
It is modal. Showmodal is set to TRUE

Is there an alternative method to sourcing a range from the spreadsheet?

--

Dave Peterson

Thanks you a life saver

Dave Peterson wrote in message ...
Use application.inputbox.

dim myRng as range
set myrng = nothing
on error resume next
set myrng = application.inputbox(prompt:="hi there!",type:=8)
on error goto 0

if myrng is nothing then
'user hit cancel
else
'you have a range
end if



Presspley wrote:

(Presspley) wrote in message . com...
It is modal. Showmodal is set to TRUE

Is there an alternative method to sourcing a range from the spreadsheet?