????? ????? ?????? ??? ???? ???? ComboBox ?? ???? ???? ListBox ?? ?????? Excel ?? Word?

???? ???????: 161598 - ??? ???????? ???? ????? ????? ??? ???????.
?????? ??? ???? ?? ??? ??????? ???? ?? Microsoft Excel ????? ??????? Mac? ???? ??????? ??????? 185388
(http://support.microsoft.com/kb/185388/ )
. (?? ????? ??? ??????? ??? ???????? ??? ????? ?????? ?????????? (????? ?? ??? ?????? ???))
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ??????? ???? ???? ???? "???? ????? ????" ?? ???? ???? "???? ?????".
???? ??? ?????? | ????? ???????

??????? ????

???? Microsoft ??????? ???????? ???? ??????? ???? ??? ?? ???? ???? ?? ????. ?????? ???? ??? ???? ?????? ?? ?????? ???????? ??????? ?????? ???????? ?? ???????? ???? ????. ????? ??? ??????? ??? ????? ??? ??? ??????? ???? ??? ????? ???????? ????????? ?????? ????????? ????????. ???? ??????? ????? ??? Microsoft ??? ??????? ?????? ?????? ????? ???? ?? ?????? ?????? ??? ??????? ?????? ????? ?????? ?? ????? ??????? ???? ???????? ??????.

????? ?? ????????? ??? ?????? ????? ???????? ???? ????? ??????? ????? Microsoft? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://support.microsoft.com/default.aspx?scid=fh;ar-sa;CNTACTMS
(http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS)
?????? ??????? ???? ???? ??? ???? ????? ???? ?? ???? ????? ?? ????? ???????. ?? ?????? Microsoft Excel? ???? ??????? ????? ?????? ??? ?? ???? ?????. ?????? ??? ??? ????? ??????. ?????? ??????? ???????? ?? ??? ??????? ????? ?????? ?? ????? ??????.

??????? ??????: ????? ??? ???? ????? ???? ?? ???? ????? ?? ???? ??? Excel

  1. ?? ?????? ???? ??? ????? ?? Microsoft Excel. ?? ???? ?? ???? ??????:
          A1: One     B1: Red
      A2: Two     B2: Green
      A3: Three   B3: Yellow
      A4: Four    B4: Blue
  2. ???? ?????? ALT+F11 ???? ????? ???? Microsoft Excel Visual Basic.
  3. ?? ??????? Insert (?????)? ???? ??? UserForm (????? ??????).
  4. ?? ?????? ???? ???? ???? ????? ???? ????? ???? ???? ????? ?? ????? ????????.
  5. ??? ?? ??? ?????? Properties "?????" ??????? ???? ??? Properties Window (???? ???????) ?? ??????? View (???).
  6. ???? ??? ComboBox (???? ????? ????)? ?? ?? ???????? ??? RowSource (???? ????) ?? Properties window (???? ???????).

    ????? ?????? ??? ?????. ????? ????? ?????? ??? ??? ????? ???? ??????. ?????? ????? ?????? ??? ???? ???????. ???? ?? ????? ?????? ?? "???? ????"? ?? ???? "sheet1!a1:a4" (??? ?????? ????????).
  7. ???? ??? ListBox (???? ?????)? ?? ?? ???????? ??? RowSource (???? ????) ?? ?????? Properties. ???? ?? ????? ?????? ?? "???? ????"? ?? ???? "sheet1!b1:b4" (??? ?????? ????????).

    ??????: ??? ??? ???? ???? ??????? ??? ??? ????? ???? ???? ??????? ?????? ????? ??????? ????????? ?? ??????? ???????? ?? ???? ????? ?????? ??? ????? ????? ????????. ?????? ?? ??????? ???????? ?? ??? ???? ????? ????? ???? ????? ????????? ?? ?????? ???? ?????? ??? ?? ???? ?? ???????. ???? ????? ???????? ????????? ???????? ?? ?????? ??????? ?? ??? ?????? ???? ?????? ?? "???? ????". ????? ???? ????? ?????? ??????? ???????? ???????? ?? ?????? ?????? ???? ????? ????????.
  8. ?? ?????? ????? ???????? ?????? ??? Run (?????)? ?? ????? ??? Run Sub/UserForm.
???? ??????? One ?Two ?Three ?Four ?? ???? ???? "???? ??????? ??????"? ????? ???? ??????? Red ?Green ?Yellow ?Blue ?? ???? ?????? "???? ???????".

??????? ???????: ????? ??????? ????? Visual Basic Macro ???? ???? ????? ???? ?? ???? ?????

  1. ???? ??? ??????? Microsoft Office ??? Microsoft Excel ?? Microsoft Word.
  2. ???? ?????? ALT+F11 ???? ????? ???? Visual Basic.
  3. ?? ??????? Insert (?????)? ???? ??? UserForm (????? ??????).
  4. ?? ?????? ???? ???? ???? ????? ???? ????? ???? ???? ????? ?? ????? ????????.
  5. ???? ??? ?????? ?????? ??? ????? ????????? ?? ???? ??? View Code (??? ????????? ????????). ???? ???? Code "???????? ????????" ?????? ????????. ???? ??? Initialize (?????) ?? ??????? Procedure (?????) (?? ?????? ??????).

    ??? ????? ?????? ????? ??????? ?? ??????? ?????? ????????? ???? ??? ???? ??????? ???????? ??? ??????.
  6. ???? ???????? ???????? ???????: 
          ListBox1.List = Array("One", "Two", "Three", "Four")?
      ComboBox1.List = Array("Red", "Green", "Yellow", "Blue")?
    ???? ??? ???????? ???????? ??? ??????? "Sub UserForm_Initialize(?)?" ?"End Sub".
  7. ?? ??????? Run (?????)? ???? ??? Run Sub/UserForm ?????? ????? ????????.
???? ??????? One ?Two ?Three ?Four ?? ???? ?????? "???? ???????"? ????? ???? ??????? Red ?Green ?Yellow ?Blue ?? ???? ???? "???? ??????? ??????".
???? ??? ?????? | ????? ???????

?????

????? ?? ????????? ??? ????? ??????????? ???? ??? ????? ??????? Index (??????) ?? ??????? Microsoft Visual Basic? ?? ???? ???? ??????:
UserForm Object
? ?? ???? ????? ??????? ??? ???? ?????? ???????? ??? ????? UserForm Object "???? ????? ????????".
???? ??? ?????? | ????? ???????

???????

???? ???????: 161598 - ????? ??? ??????: 20/????/1432 - ??????: 4.0
????? ???
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Word 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Word 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Word 97 Standard Edition
  • Microsoft Word 2010
  • Microsoft Office Word 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2010
  • Microsoft Office Excel 2007
  • Microsoft Office Word 2003
????? ??????: 
kbcontrol kbdtacode kbhowto kbprogramming KB161598
???? ??? ?????? | ????? ???????

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

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