View Single Post
 
Old 06-03-2014, 10:56 AM
gmaxey gmaxey is offline Windows 7 32bit Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,617
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

Code:
While .Execute
      oRng.Select
      Select Case MsgBox("Do you want to show dual values?", vbYesNoCancel, "CREATE DUAL VALUE")
        Case vbYes
          Set oRngNums = oRng.Duplicate
          oRngNums.Collapse wdCollapseStart
          oRngNums.MoveStartWhile Cset:="1234567890 ", Count:=wdBackward
          strNums = Trim(oRngNums.Text)
          oRng.Text = arrEng(lngIndex) & " (" & CDbl(arrFactors(lngIndex)) * CDbl(strNums) & " " & arrMet(lngIndex) & ")"
          oRng.Collapse wdCollapseEnd
        Case vbNo
          oRng.Collapse wdCollapseEnd
        Case Else
          Exit Sub
      End Select
    Wend
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote