EXCEL中如何实现单元格自动跳转（能解决问题再加50分）

显示全部楼层 · 2013-4-16 10:06:01

数据有效性做不了，得用VBA。在A1上添加一个组合框控件ComboBox，然后按Alt+F11，双击Sheet1，输入以下代码： Private Sub ComboBox1_Change()If ComboBox1.Text = "三班" Then Application.Goto Reference:=Cells(120, 1)If ComboBox1.Text = "五班" Then Application.Goto Reference:=Cells(260, 1)End SubPrivate Sub...

千问 · 2013-4-16 10:06:01

用vba,把具体要求说清楚Private Sub Worksheet_Change(ByVal Target As Range)If Target.Count = 1 ThenIf Target.Address = "$A$1" ThenSelect Case Target.ValueCase "三班"Application.Goto Reference:...

千问 · 2013-4-16 10:06:01

http://wenku.baidu.com/view/456f9420af45b307e871970c.html...