????? ?? ??? ?? ???? ??? Excel ?????? Mac ?? ????????

?????? ????????? ?????? ?????????
???? ???????: 189629 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

???????

??? ??????? ???? ?????? ??? ?????? ???? ??????? ????? Microsoft Excel ?? Mac ???? ??????? ?????? ?? ???? ????? ?????? ??? (??? ??? ??? ?????? ????? ??? ?????? ????? ??? ??? ?????????).

??? ????????? ??? ????? ?? ???? ????? ?????? ??? ??????? ??? ???? ???? ?? ???????? Excel ?? Mac ?? ??? ??? ??????? ??? ???? ?????? ?? ???????? ?? ??? ??????; ??? ???? ???? ?? ??? ????? ??? ????? ????? ?????.

??????: ??? ??? ????? ??? ??????? ????? ???????. ???? ??? ????? ??? ??? ???????.

?????

???? ??? ??????? ??? ?? ???? ????? ??? ??? ????? ????? ???????. ???? Excel ?? Mac ??????? ??? ??? ?? ????? ?????? ?? ??????? ????? ??? ???? ???? ??????? ?? ???????? ???????? ??????? ??????? ?? Visual Basic. ??? ??? ?? ?????? ??????. ??? ????? ????? ??? ?????? ???????? ????? ??? ????? ?? ??????? ?? ???? ??? ?????? ??? ??????? ????? ??? ?? ??????.

???? ??????

???? Microsoft ??????? ???????? ??? ??? ?? ???? ??????? ?? ?? ?????. ??? ????? ???? ?? ????? ??? ???????? ??????? ?????? ???????? ?? ???????? ???? ????. ????? ??? ??????? ???? ?????? ?? ??? ??????? ???? ??? ????? ?? ??????? ???? ??? ????????? ?????? ?????? ?????????. ???? ??????? ????? ??? Microsoft ??? ????? ????? ???? ???? ?? ?????? ?????? ??? ??????? ?????? ????? ?????? ?? ????? ??????? ?????? ??????? ?????. ??????? ?????? ??? ??? ??????? ????? ??????? Microsoft Visual Basic ??????? ????????? (????? Sub) ????? ?? ?? ???? ??? ?? ?????? ?? ??? ??????. ?????? "???????" ? ???? ??????? ???????:
  1. ??? ?? ???????? ???????? ???????? ?? ????? ???? ????.
  2. ?? ??????? ?????? ??? ??? ????? ? ?? ???? ??? ???? Visual Basic.
  3. ?? ??????? ????? ? ???? ??? ???? ?????.
  4. ???? ???????? ???????? ??????? ?? ?????? ???????:
    Sub FindData()
    
       ' This Sub prompts you for a value and searches each worksheet
       ' that is selected in group mode. If it finds the search value,
       ' the routine prompts you to continue the search on the sheet.
       ' If it does not find the value on the sheet, it goes to the
       ' next sheet. You can cancel the search on the sheet by
       ' answering No to "Look for another value..." and then
       ' answering Yes to "Cancel the search ...".
       '
       ' WARNING: When this macro ends, the workbook will no longer be
       ' in group mode.
    
       testValue = InputBox("Enter the value to search for : ")
       For Each x In ActiveWindow.SelectedSheets
          x.Select
          Set foundcell = ActiveSheet.Cells.Find(testValue)
           If foundcell Is Nothing Then
               MsgBox "The word was not found"
           Else
               MsgBox "The word was found in cell " & foundcell.Address
               Range(foundcell.Address).Select
    
        LookAgain:
               response = MsgBox _
                   ("Look for another value on this sheet?", vbYesNo)
    
               ' If response = 6, we will not continue searching on
               ' this sheet.
               If response = 6 Then
    
                   ' Part2
                   Set foundcell = _
                       ActiveSheet.Cells.FindNext(after:=ActiveCell)
                   Range(foundcell.Address).Select
                   GoTo LookAgain
               End If
    
               If response = 7 Then
                   response = MsgBox("Cancel search ? ", vbYesNo)
                   If response = 6 Then End
                   GoTo NextSheet
               End If
           End If
    
      NextSheet:
          Next x
          MsgBox "Search is complete ....."
    
    End Sub
    					
  5. ?? ??????? ??? (?? ??????? Excel ?? Microsoft Excel X ?? Mac) ? ???? ??? ????? ????? ??? Microsoft Excel.
  6. ??? ????? ????? (??? ????????) ???? ???? ?????. ?????? ??????? ???????? ????? ?????? ????:
    • ??? ??? ???? ?? ????? ????? ??????? ?? ????? ???? ??? ????? ??????? ?????? ?????? ?? ???? ???????? ??????? SHIFT ? ???? ??? ????? ??????? ?????? ???????.

      - ?? -
    • ??? ??? ???? ?? ????? ?????? ?? ???? ?? ????? ??? ??????? ???? ??? ????? ??????? ?????? ?????? ?? ???? ???????? ??? ??????? COMMAND ? ???? ??? ?????? ????? ??????? ??????.

      - ?? -
    • ??? ??? ???? ????? ???? ??????? ?? ?????? ???? ???????? ??? ??????? CONTROL ? ?? ???? ??? ????? ????? ?????? ?? ???? ??? ????? ???? ??????? ??????? ????????.
  7. ?? ??????? ?????? ??? ??? ????? ? ?? ???? ??? ????? ???????.
  8. ???? ??? ??????? FindData ?? ???? ??? ?????. ???? ????????? ?? ?????? ?????? ???? ????.

?????

????? ?? ????????? ??? ????? ??? ???? ??? Microsoft Excel ?? Mac ??????? ?? ??????? ??????? ? ???? ????? ?? ?? ??????? ???????? ?? ????? Office "??" ????? ??????? ?? ???? ??? ??? ???? ???????? ???? ?? ???????.

???????

???? ???????: 189629 - ????? ??? ??????: 04/????/1428 - ??????: 3.2
????? ???
  • Microsoft Excel 2004 for Mac
  • Microsoft Excel X ?? Mac
  • Microsoft Excel 2001 ?? Macintosh
  • Microsoft Excel 98 ?? Macintosh
????? ??????: 
kbmt kbdtacode kbprb KB189629 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????189629

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com