RefEdit causing crashes

[presspley]

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?

 

[keepITcool]

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-us/off2000/html/f3objrefedit.asp

 

[Presspley]

It is modal. Showmodal is set to TRUE

 

[Presspley]

It is modal. Showmodal is set to TRUE

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

 

[Dave Peterson]

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]

Thanks you a life saver

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