How to jump to specific cell

  • Thread starter Thread starter Milax
  • Start date Start date
M

Milax

Can anyone help me,
How can I make Excel to jump to specific cell depending on another cell
value. For example if in list box are stored values from 1 to 10 how
can go to column B row (number stored in list box)

Example:
Cell A1=1 ---> jump to B1
Cell A1=5 ---> jump to B5

Thanks!
 
application.goto range("B" & Listbox1.Value)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
find and scroll to cell string value in Excel 2
Create a macro (or function) to jump cells 1
How to do this with macro? 2
Active cell is to jump from one cell to another when conditions are met 2
Display entire number in cell 3
Arrays and scattered cell values or another way? 16

Back
Top