Hidden Spell checking dialog behind the userform

  • Thread starter Jeffery B Paarsa
  • Start date
J

Jeffery B Paarsa

Hello,

I am sure you are going to say this question does not blong to this Forum as
Visaul Studio VB.NET said so... So I am being given run around for the last
few days and I don't know how I solve my problem...

In a VB 2005 App. after collecting the data through user form I open a word
document and populate the collected data to the Texfields of the Word
document then I run the CheckSpelling and print it... Here is the code:
FaxHDF.Bookmarks.Item("FXMSG").Range.Text() = Me.FXMSG.Text
FaxHDF.FXPatient.value = Me.FXPatient.Checked
FaxHDF.FXOther.value = Me.FXOther.Checked
FaxHDF.Fields.Update()
FaxHDF.CheckSpelling()
FaxHDF.PrintOut()
FaxHDF.Close(False)

My problem is that the spell checking dialog box hides behind the userform
and gives the impression to the user that application is stopped/abended/in a
loop and not working.
How can I bring the spell checking dialog to the front of the userform?

I want this spelling dialog box to be focused on top of my userform and not
to be hidden on the back of userform... so user sees his/her spelling problem
and take necessary action...

VB Forum says spell checking dialog blongs to Word and through VB you can do
anything and put the dialog focused or brought in front of userform...

Regards

Jeff B Paarsa
 
D

Doug Robbins - Word MVP

Hide the UserForm before calling the spelling checker.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
 
J

Jean-Guy Marcil

Jeffery B Paarsa was telling us:
Jeffery B Paarsa nous racontait que :
Hello,

I am sure you are going to say this question does not blong to this
Forum as Visaul Studio VB.NET said so... So I am being given run
around for the last few days and I don't know how I solve my
problem...

In a VB 2005 App. after collecting the data through user form I open
a word document and populate the collected data to the Texfields of
the Word document then I run the CheckSpelling and print it... Here
is the code: FaxHDF.Bookmarks.Item("FXMSG").Range.Text() =
Me.FXMSG.Text FaxHDF.FXPatient.value = Me.FXPatient.Checked
FaxHDF.FXOther.value = Me.FXOther.Checked
FaxHDF.Fields.Update()
FaxHDF.CheckSpelling()
FaxHDF.PrintOut()
FaxHDF.Close(False)

My problem is that the spell checking dialog box hides behind the
userform and gives the impression to the user that application is
stopped/abended/in a loop and not working.
How can I bring the spell checking dialog to the front of the
userform?

I want this spelling dialog box to be focused on top of my userform
and not to be hidden on the back of userform... so user sees his/her
spelling problem and take necessary action...

VB Forum says spell checking dialog blongs to Word and through VB you
can do anything and put the dialog focused or brought in front of
userform...

Have you tried "sandwiching" your userform between a hide/show pair:

Me.Hide

ActiveDocument.CheckSpelling

Me.Show
 
J

Jeffery B Paarsa

That can be done in VBA but I have tried it before and it does not work in
VB. It gives an error "UserForm is not a member of Project.Userform"...
etc...
 
J

Jeffery B Paarsa

Thank you... Yes it worked...
--
Jeff B Paarsa


Jean-Guy Marcil said:
Jeffery B Paarsa was telling us:
Jeffery B Paarsa nous racontait que :


Have you tried "sandwiching" your userform between a hide/show pair:

Me.Hide

ActiveDocument.CheckSpelling

Me.Show
 
D

Doug Robbins - Word MVP

And what if you omit the Me.show? In other words, hide the userform.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top