Right click in Macro

MShroff · #1 04-05-2011, 06:22 PM

When making a macro i want to right click on the word - how can I do that? I am trying to record a macro where I right click on a misspelled word (eg bigboy) and then select the first option where the word is corrected to big boy. Word will not let me right click when recording. How can I get around this?

Thank you
M Shroff

macropod · #2 04-05-2011, 07:01 PM

Hi M Schroff,

You could simulate the right-click with:
SendKeys ("+{F10}")

MShroff · #3 04-05-2011, 07:26 PM

My apologies, I dont get it. I am not very WORD savvy!

MShroff

macropod · #4 04-05-2011, 08:23 PM

Hi M Schroff,

I don't really understand why you want a sub with the right-click approach, when you could use a sub like:

Code:

Sub Demo()
Selection.Range.CheckSpelling
End Sub

The Sendkeys code is what you'd add to a sub to simulate the right-click after something has been selected (either by the user before running the sub or by the sub itself). For example:

Code:

Sub Demo()
Dim StrWrd As Range
For Each StrWrd In ActiveDocument.Paragraphs(1).Range.Words
  With StrWrd
    If .SpellingErrors.Count > 0 Then
      .Select
      SendKeys "+{F10}", True
      Exit Sub
    End If
  End With
Next
End Sub

MShroff · #5 04-05-2011, 09:00 PM

Thank you for your help.
M Shroff

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Alter right click menu?	markg2	Office	1	01-10-2011 08:10 AM
Click -to run headache	lazarus34	Office	0	09-14-2010 08:42 AM
Can't click on links in email	MrJP	Outlook	1	08-28-2010 06:39 PM
What is this right-click sub-menu called?	wornways	Word	3	08-13-2010 09:17 PM
My Subforms jump when I click the tab	jbryanh	Office	1	10-13-2005 07:12 AM