Document Doesn't Update on Button Click

C

Cameron Powell

I have a UserForm that will pull the name, fax #, and phone # from Outlook.
When you click Add Recipient, the text boxes clear, but until I hit finish or
add another recipient, The information does not show up on the document.

Private Sub cmdAdd_Click()
ActiveDocument.Tables(1).Rows(4).Select
Selection.InsertRowsAbove
With ActiveDocument.Tables(1)
.Cell(4, 2).Range.Text = txtTo.Value
.Cell(4, 3).Range.Text = txtFax.Value
.Cell(4, 4).Range.Text = txtPhone.Value
End With
txtTo.Value = ""
txtFax.Value = ""
txtPhone.Value = ""
End Sub
 
J

Jean-Guy Marcil

Cameron Powell was telling us:
Cameron Powell nous racontait que :
I have a UserForm that will pull the name, fax #, and phone # from
Outlook. When you click Add Recipient, the text boxes clear, but
until I hit finish or add another recipient, The information does not
show up on the document.

And the problem is...?

As long as the info ends up where it should, and it seems it does, there are
no problems, no?

And if the userform is modal, the user will never see this "problem".

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org
 
C

Cameron Powell

Well the problem is for those of us with short term memories, how exactly
would we know the last person that we entered... Shouldn't I be able to just
click the button and have the changes immediatly display?
 
J

Jean-Guy Marcil

Cameron Powell was telling us:
Cameron Powell nous racontait que :
Well the problem is for those of us with short term memories, how
exactly would we know the last person that we entered... Shouldn't I

If you just entered it, how would you end up entering it again? And if the
userform is still onscreen, you cannot really see what is going on in the
document, no?
be able to just click the button and have the changes immediatly
display?

Yes, but it depends on the code as a whole, you may have bits of code you
did not show us that interfere...

Sorry, but I fail to fully grasp the issue at hand.

Can you describe the process, i.e. what it should do (your expectations) and
what it does in a step by step fashion?

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org
 

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