Skip to main content

Conas cúrsóir a bhogadh go huathoibríoch chuig cill ar leith in Excel?

Uaireanta, b’fhéidir go mbeidh ort léim go cill ar leith chun críche éigin. Taispeánfaidh an t-alt seo duit modhanna chun cúrsóir a aistriú go cill ar leith go mion.

Cúrsóir bogadh uathoibríoch go cill ar leith leis an mbosca Ainm
Cúrsóir bogadh uathoibríoch go cill ar leith le cód VBA

Cúrsóir bogadh uathoibríoch go cill ar leith leis an mbosca Ainm

Is féidir leis an mbosca Ainm cabhrú leat cúrsóir a aistriú go cill ar leith in Excel.

1. Sa Ainm bosca, iontráil an tagairt chill shonrach a léimfidh tú dó, agus ansin brúigh an Iontráil eochair.

Ansin bogann an cúrsóir go dtí an cill shonraithe láithreach.

nótaí: Más gá duit léim go dtí an chill shonraithe i mbileog oibre eile, mar shampla léim go cill C30 de Bhileog2, clóscríobh le do thoil Bileog2! C30 isteach sa bhosca Ainm, agus ansin brúigh an Iontráil eochair.

Cúrsóir bogadh uathoibríoch go cill ar leith le cód VBA

Cuidíonn an cód VBA seo a leanas leat bogadh go cill ar leith ag an am céanna in Excel.

1. Brúigh Eile + F11 eochracha ag an am céanna chun an Microsoft Visual Basic d’Fheidhmchláir fhuinneog.

2. Sa Microsoft Visual Basic d’Fheidhmchláir fuinneog, cliceáil faoi dhó T.a Leabhar Oibre sa phána clé chun an T a oscailta Leabhar Oibre (Cód) fuinneog. Ansin cóipeáil agus greamaigh an cód VBA thíos san fhuinneog.

Cód VBA: Bog go dtí tús nó tús an chéad tsraith eile le haghaidh sonraí a iontráil

Sub jumpnext()
    Range("F100").Select
End Sub

nótaí: Sa chód, is é F100 an chill shonraithe a léimfidh tú dó. Is féidir leat é a athrú de réir mar is gá duit.

3. Brúigh an F5 eochair chun an cód a rith, ansin bogann an cúrsóir go cill F100 sa bhileog oibre reatha láithreach.

Earraí gaolmhara:

Uirlisí Táirgiúlachta Oifige is Fearr

🤖 Kutools AI Aide: anailís sonraí a réabhlóidiú bunaithe ar: Forghníomhú Chliste   |  Gin Cód  |  Cruthaigh Foirmlí Saincheaptha  |  Anailís a dhéanamh ar Sonraí agus Cairteacha a Ghin  |  Feidhmeanna Kutools a agairt...
Gnéithe Coitianta: Faigh, Aibhsigh nó Aithnigh Dúblaigh   |  Scrios Sraitheanna Bána   |  Comhcheangail Colúin nó Cealla gan Sonraí a Chailleadh   |   Babhta gan Foirmle ...
Cuardaigh Super: Ilchritéir VLookup  |   VLookup Illuachanna  |   VLookup Trasna Ilbhileoga   |   Amharc doiléir ....
Liosta anuas Casta: Go tapa Cruthaigh Liosta Anuas   |  Liosta anuas Cleithiúnach   |  Liosta Buail Isteach Ilroghnacha ....
Bainisteoir Colún: Cuir Líon Sonrach Colún leis  |  Colúin Bog  |  Scoránaigh Stádas Infheictheachta na gColún Ceilte  |  Déan comparáid idir Raonta & Colúin ...
Gnéithe Réadmhaoin: Fócas Eangaí   |  Amharc Dearaidh   |   Barra Mór na Foirmle   |  Leabhar Oibre & Bainisteoir Bileog   |  Leabharlann Acmhainní (Uaththéacs)   |  Piocálaí Dáta   |  Comhcheangail Bileoga Oibre   |  Criptigh/Díchriptigh Cealla   |  Seol Ríomhphost trí Liosta   |  Scagaire Super   |   Scagaire Speisialta (scagaire trom/iodálach/stailc tríd...) ...
Barr 15 Uirlisí:  12 Téacs uirlisí (Cuir Téacs, Bain Carachtair,...)   |   50 + Cairt cineálacha (Cairt Gantt,...)   |   40+ Praiticiúil Foirmlí (Ríomh aois bunaithe ar lá breithe,...)   |   19 Insertion uirlisí (Cuir isteach Cód QR, Ionsáigh Pictiúr ón gCosán,...)   |   12 Tiontú uirlisí (Uimhreacha le Focail, Comhshó Airgeadra,...)   |   7 Cumaisc & Scoilt uirlisí (Sraitheanna Comhcheangail Casta, Cealla Scoilt,...)   |   ... agus eile

Supercharge Do Scileanna Excel le Kutools le haghaidh Excel, agus Éifeachtúlacht Taithí Cosúil Ná Roimhe. Kutools le haghaidh Excel Tairiscintí Níos mó ná 300 Ardghnéithe chun Táirgiúlacht a Treisiú agus Sábháil Am.  Cliceáil anseo chun an ghné is mó a theastaíonn uait a fháil ...

Tuairisc

Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
Comments (16)
No ratings yet. Be the first to rate!
Trang Gia Ky (Mr.)
Trang Gia Ky (Mr.)
This comment was minimized by the moderator on the site
Dear,
Please help me how to code : I want to move down row by row on tthe data already fillter
Current cursor at A6 (fix) because it 's Row Header, I want to move down :
Step 1 : move down to A9
Step 2 : move down to A11
Step 3 : move down to A15
(Do until blank)
Screenshot 2023-11-30 200730
(Please see srceen shot attacked)

Many Thanks
Ky
Reply
0
0
arvind
arvind
This comment was minimized by the moderator on the site
Sub jumpnext()
Range("F100").Select
End Sub

What chnage do i have to do so this code can be uased on all sheets of the workbook at the same time.

Regards,
Reply
0
0
crystal
crystal     arvind
This comment was minimized by the moderator on the site
Hi arvind,

The following VBA code can do you a favor. Please give it a try. Thank you.
Note: You need to put the VBA code in the ThisWorkbook (Code) editor.
Sub jumpnext()
'Updated by Extendoffice 20230109
Set CurrWS = ActiveSheet
    For Each WS In ThisWorkbook.Worksheets
    WS.Activate
        WS.Range("F100").Select
    Next
    CurrWS.Activate
End Sub

https://www.extendoffice.com/images/stories/comments/comment-picture-zxm/select-same-cell.png
Reply
Report
0
0
Andy Coghlan
Andy Coghlan
This comment was minimized by the moderator on the site
Hi,

Can you help with the following VBA code request please?

Sheet 1 is named "Master Asset" with a further 100 sheets named as "0001...0002...0003....0004 ~ 0100"

In any of each of the sheets "0001 ~ 0100"
I want to be able to select cell A4 which already contains text "Back to Master Asset" then press enter, to automatically jump back to cell J3 in the "Master Asset"

Thanks in advance.
Andy C.
Reply
0
0
crystal
crystal     Andy Coghlan
This comment was minimized by the moderator on the site
Hi Andy Coghlan，
I can't find a way to trigger the macro with the enter key right now. The following VBA code can insert the same hyperlink in A4 of all worksheets at the same time. After clicking the hyperlink in A4, it will jump to J3 in the "Master Asset". Please give it a try.

Sub AddHyperlinks()
'Updated by Extendoffice 20220715
    Dim xRg, yRg As Range
    Set xRg = Worksheets("Master Asset").Range("J3")
    xStr = xRg.Address(External:=True)
    For Each Sh In Worksheets
        If Sh.Name <> "Sh.Name" Then
            Set yRg = Sh.Range("A4")
            yRg.Hyperlinks.Add anchor:=yRg, Address:="", SubAddress:=xStr, TextToDisplay:="Back to Master Asset"
        End If
    Next
End Sub
Reply
Report
0
0
Nelson
Nelson
This comment was minimized by the moderator on the site
Bagiaimana mengisi textbox pada form dengan memilih data di cell/sheet yg dipilih dgn kursor ?
Reply
0
0
crystal
crystal     Nelson
This comment was minimized by the moderator on the site
Hi Lelson,
Sorry I don't understand what you mean. Would you mind providing a screenshot of your data? Or try to be more specific about your question. Sorry for the inconvenience.
Reply
Report
0
0
Shahad
Shahad
This comment was minimized by the moderator on the site
you didn't sign the F5 for teh code, how it is gonna run by pressing F5?
Reply
0
0
John
John
This comment was minimized by the moderator on the site
Is it possible to move the active cell without pressing a key on the keyboard? For example, can I have the cell move down as soon as the cell above it is filled? I am looking for either a function or a VBA to run when a cell is filled. As soon as A3 has characters in it, is there a VBA to move the active cell down to A4?
Reply
0
0
crystal
crystal     John
This comment was minimized by the moderator on the site
Hi John,
I am confused on your question. How can we know if the cell is finish editing?
Reply
Report
0
0
James
James
This comment was minimized by the moderator on the site
Sorry I mean to type "instantly jump to F8"
Reply
0
0
crystal
crystal     James
This comment was minimized by the moderator on the site
Hi James,
Please try the below code. After data has been entered into E6, press the Tab key or the Enter key, and the cursor will jump to F8 instantly.

Private Sub Worksheet_Change(ByVal Target As Range)

'Updated by Extendoffice 2020087

Dim tabArray As Variant

Dim i As Long

tabArray = Array("E6", "F8")

Application.ScreenUpdating = False

For i = LBound(tabArray) To UBound(tabArray)

If tabArray(i) = Target.Address(0, 0) Then

If i = UBound(tabArray) Then

Me.Range(tabArray(LBound(tabArray))).Select

Else

Me.Range(tabArray(i + 1)).Select

End If

End If

Next i

Application.ScreenUpdating = True

End Sub
Reply
Report
0
0
james
james
This comment was minimized by the moderator on the site
How would I have the cursor move from Cell E6 to F8 once data has been entered into E6? I would like the cursor to ignore all the other lines in the E column and instantly jump to E6.
Reply
0
0
Steve
Steve
This comment was minimized by the moderator on the site
That's helpful thanks. However I would like to have a formula as the argument for the 'Range' function. Is this permissible? What I would like to do is have the user enter a number in a dialog box, then search for the first occurrence of that number in a range of cells, and then jump the cursor to that cell...
Reply
0
0
crystal
crystal     Steve
This comment was minimized by the moderator on the site
Hi Steve,
Sorry can't help you with that.
Reply
Report
0
0
Kris
Kris
This comment was minimized by the moderator on the site
I'd like to make a macro that moves from one cell to the next, step by step.
Reply
0
0
There are no comments posted here yet
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations