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)

"Milax" wrote in message
...
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!

Bob Phillips wrote:
application.goto range("B" & Listbox1.Value)

--

HTH

Bob Phillips

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

"Milax" wrote in message
...

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!



Thanks!