RefEdit

[Guest]

We are having a problem with the reference editor. When we bring up our form sometimes a hidden refedit shows up and locks up Excel and all forms within Excel. Is there a way to work around the refedit or close them via VBA

Sincerely
Matt and a CWU CS481 grou

 

[Rob van Gelder]

RefEdit is a funny control, handy if you get it right.

Non-modal or modal form?

--
Rob van Gelder - http://www.vangelder.co.nz/excel

We are having a problem with the reference editor. When we bring up our

form sometimes a hidden refedit shows up and locks up Excel and all forms
within Excel. Is there a way to work around the refedit or close them via
VBA?

 

[Tom Ogilvy]

Hopefully modal since a refedit does not work on a modeless/non-modal
userform - so stated in help for the refedit and cited many times in this
group - it causes a GPF I believe.

 

[Harald Staff]

It does work somehow -but the modeless form never dies, you must Ctrl Alt Delete your way
out of Excel. Same thing as a gpf in the end I guess

Another problem with refedit: Don't put it in a container (multitab, frame, ...) but
directly onto the userform.

 

[Jon Peltier]

Also try to avoid using RefEdit event procedures. Instead of
RefEdit_Change, you could trap the GotFocus event of the other controls.

- Jon

 

[Guest]

Thanks guys, I will look into it and see if it is Modal..
Mat

 

[Guest]

Well, it is on a Modal form, however, does having it on a tab change anything?

 

[Rob van Gelder]

It's very likely that having it contained within another control will have
an effect.

--
Rob van Gelder - http://www.vangelder.co.nz/excel

Well, it is on a Modal form, however, does having it on a tab change

anything?