åè®¾ä½ æä¸ä¸ªComboBox1ï¼ç¡®ä¿éåºç¼è¾æ¨¡å¼ãå³é®ç¹è¯¥å·¥ä½è¡¨çååï¼å¨å·¥ä½ç°¿çå·¦ä¸æ¹å¢ï¼ï¼æ¥ç代ç ï¼ç²è´´å¦ä¸ä»£ç ï¼ Private Sub Worksheet_SelectionChange(ByVal Target As Range) ComboBox1.Text = Target.Value End Sub åå°Excelï¼ä»»æç¹æåå æ ¼ï¼èµå¼å°ComboBoxã