如何使用VBA在excel中保持第一个单元格始终处于活动状态 [英] how to keep the first cell always active in excel using vba

问题描述

打开Excel工作表时如何保持第一个单元格始终处于活动状态.

How to keep the first cell always active when opening the excel sheet.

任何人都可以指导我如何做到这一点.

Can any one guide me to how to this.

这是我的 代码:

       Private Sub Send_Click()
       Dim strURL As String
       strURL = "http://xxxxxxxxxxxx.com/excelAPI.php?customer_id=1&mobilenumber=" _
       & ActiveCell.Value & "&message=" & ActiveCell.Offset(0, 1).Value
       Call Sheets("Sheet1").WebBrowser4.Navigate(strURL)

       End Sub

推荐答案

我不太确定您为什么希望第一个单元处于活动状态.如果仅仅是因为您在代码中使用了 ActiveCell ，那么您应该定义一个Range.像这样:

I'm not quite sure why you would want the first cell to be active. If it's just because you are using ActiveCell in your Code then you should be defining a Range instead. Like this:

Private Sub Send_Click()
   Dim strURL As String
   strURL = "http://xxxxxxxxxxxx.com/excelAPI.php?customer_id=1&mobilenumber=" _
   & Range("A1").Value & "&message=" & Range("A1").Offset(0, 1).Value
   Call Sheets("Sheet1").WebBrowser4.Navigate(strURL)
End Sub

无论如何.这是打开工作簿时激活 YourWorksheet 的第一个单元格(A1)的方式:

Anyway. This is how you activate the first cell (A1) of YourWorksheet when the Workbook is opened:

Private Sub Workbook_Open() 
   Worksheets("YourWorksheet").Activate
   Range("A1").Activate
End Sub

这篇关于如何使用VBA在excel中保持第一个单元格始终处于活动状态的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！