ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VB Editor and Moving Line Pointer (https://www.excelbanter.com/excel-programming/427133-vbulletin-editor-moving-line-pointer.html)

Tim Childs[_2_]

VB Editor and Moving Line Pointer
 
Hi

I am editing and debugging code in the editor on a LAPTOP. The problem is
that using the left button touchpad mouse I am not able to drag the yellow
pointer in "step-through" mode. All that happens when I press the left
button is that I get a new break-point. Apart from getting a conventional
mouse, is there a tip or workaround, please?

Many thanks

Tim



Nigel[_2_]

VB Editor and Moving Line Pointer
 
You step through code using the debug toolbar controls. The panel to left
of code is for setting breakpoints only.
--

Regards,
Nigel




"Tim Childs" wrote in message
...
Hi

I am editing and debugging code in the editor on a LAPTOP. The problem is
that using the left button touchpad mouse I am not able to drag the yellow
pointer in "step-through" mode. All that happens when I press the left
button is that I get a new break-point. Apart from getting a conventional
mouse, is there a tip or workaround, please?

Many thanks

Tim



Andy Pope

VB Editor and Moving Line Pointer
 
Hi,

Perhaps you could use the Keyboard shortcut.
On the line where you want to step to use CTRL+F9

Cheers
Andy

Tim Childs wrote:
Hi

I am editing and debugging code in the editor on a LAPTOP. The problem is
that using the left button touchpad mouse I am not able to drag the yellow
pointer in "step-through" mode. All that happens when I press the left
button is that I get a new break-point. Apart from getting a conventional
mouse, is there a tip or workaround, please?

Many thanks

Tim



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Andy Pope

VB Editor and Moving Line Pointer
 
Hi,

Not exactly true. A single left click will indeed toggle breakpoints.
But when stepping through the code you can select the Yellow Arrow and
drag it. When hovering over the arrow the cursor changes to display
up/down and Right arrows.

The panel can also display Bookmarks.

Cheers
Andy

Nigel wrote:
You step through code using the debug toolbar controls. The panel to
left of code is for setting breakpoints only.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Nigel[_2_]

VB Editor and Moving Line Pointer
 
Thanks Andy, never used it!

--

Regards,
Nigel




"Andy Pope" wrote in message
...
Hi,

Not exactly true. A single left click will indeed toggle breakpoints.
But when stepping through the code you can select the Yellow Arrow and
drag it. When hovering over the arrow the cursor changes to display
up/down and Right arrows.

The panel can also display Bookmarks.

Cheers
Andy

Nigel wrote:
You step through code using the debug toolbar controls. The panel to
left of code is for setting breakpoints only.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


Dave Peterson

VB Editor and Moving Line Pointer
 
Maybe you can use the keyboard.

After you've started stepping through the code, click on Debug on the toolbar.

You'll see some options with their corresponding keyboard shortcuts.



Tim Childs wrote:

Hi

I am editing and debugging code in the editor on a LAPTOP. The problem is
that using the left button touchpad mouse I am not able to drag the yellow
pointer in "step-through" mode. All that happens when I press the left
button is that I get a new break-point. Apart from getting a conventional
mouse, is there a tip or workaround, please?

Many thanks

Tim


--

Dave Peterson

Tim Childs[_2_]

VB Editor and Moving Line Pointer
 
Hi to all

Many thanks for the suggestions.

However, the thing I am trying to do is drag the yellow cursor typically up
the code and it just does not "work" on the laptop - the step options are
not a complete solution because I often want to drag the yellow point UP the
code to run thru it again, using F8 etc.

Any ideas?

Thanks

Tim

"Dave Peterson" wrote in message
...
Maybe you can use the keyboard.

After you've started stepping through the code, click on Debug on the
toolbar.

You'll see some options with their corresponding keyboard shortcuts.



Tim Childs wrote:

Hi

I am editing and debugging code in the editor on a LAPTOP. The problem is
that using the left button touchpad mouse I am not able to drag the
yellow
pointer in "step-through" mode. All that happens when I press the left
button is that I get a new break-point. Apart from getting a conventional
mouse, is there a tip or workaround, please?

Many thanks

Tim


--

Dave Peterson




Andy Pope

VB Editor and Moving Line Pointer
 
Hi Tim,

Did you try the CTRL+F9 keyboard short cut?
If you move the text cursor back up the code you can step back to the
line where the cursor now is and use F8 to step forward again.

Cheers
Andy

Tim Childs wrote:
Hi to all

Many thanks for the suggestions.

However, the thing I am trying to do is drag the yellow cursor typically up
the code and it just does not "work" on the laptop - the step options are
not a complete solution because I often want to drag the yellow point UP the
code to run thru it again, using F8 etc.

Any ideas?

Thanks

Tim

"Dave Peterson" wrote in message
...

Maybe you can use the keyboard.

After you've started stepping through the code, click on Debug on the
toolbar.

You'll see some options with their corresponding keyboard shortcuts.



Tim Childs wrote:

Hi

I am editing and debugging code in the editor on a LAPTOP. The problem is
that using the left button touchpad mouse I am not able to drag the
yellow
pointer in "step-through" mode. All that happens when I press the left
button is that I get a new break-point. Apart from getting a conventional
mouse, is there a tip or workaround, please?

Many thanks

Tim


--

Dave Peterson





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Chip Pearson

VB Editor and Moving Line Pointer
 


When the code is paused a line, use the arrow keys of move the cursor
up to the desired line. Then right-click with the right-click button
(between the right-side ALT and CTRL keys on a normal keyboard --
location differs from one laptop to the next) and choose "Set Next
Statement". This will have the same effect as dragging the yellow
execution line upwards in the code.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Sat, 18 Apr 2009 14:40:56 +0100, "Tim Childs"
wrote:

Hi to all

Many thanks for the suggestions.

However, the thing I am trying to do is drag the yellow cursor typically up
the code and it just does not "work" on the laptop - the step options are
not a complete solution because I often want to drag the yellow point UP the
code to run thru it again, using F8 etc.

Any ideas?

Thanks

Tim

"Dave Peterson" wrote in message
...
Maybe you can use the keyboard.

After you've started stepping through the code, click on Debug on the
toolbar.

You'll see some options with their corresponding keyboard shortcuts.



Tim Childs wrote:

Hi

I am editing and debugging code in the editor on a LAPTOP. The problem is
that using the left button touchpad mouse I am not able to drag the
yellow
pointer in "step-through" mode. All that happens when I press the left
button is that I get a new break-point. Apart from getting a conventional
mouse, is there a tip or workaround, please?

Many thanks

Tim


--

Dave Peterson



Simon Lloyd[_1099_]

VB Editor and Moving Line Pointer
 

Dragging the arrow on a laptop works fine for me, however you could
reset to start again by clicking the stop or Alt+r+r, you can then place
a break point in to step to that.

Andy Pope;313174 Wrote:
Hi Tim,

Did you try the CTRL+F9 keyboard short cut?
If you move the text cursor back up the code you can step back to the
line where the cursor now is and use F8 to step forward again.

Cheers
Andy

Tim Childs wrote:
Hi to all

Many thanks for the suggestions.

However, the thing I am trying to do is drag the yellow cursor

typically up
the code and it just does not "work" on the laptop - the step options

are
not a complete solution because I often want to drag the yellow point

UP the
code to run thru it again, using F8 etc.

Any ideas?

Thanks

Tim

"Dave Peterson" wrote in message
...

Maybe you can use the keyboard.

After you've started stepping through the code, click on Debug on the
toolbar.

You'll see some options with their corresponding keyboard shortcuts.



Tim Childs wrote:

Hi

I am editing and debugging code in the editor on a LAPTOP. The

problem is
that using the left button touchpad mouse I am not able to drag the
yellow
pointer in "step-through" mode. All that happens when I press the

left
button is that I get a new break-point. Apart from getting a

conventional
mouse, is there a tip or workaround, please?

Many thanks

Tim

--

Dave Peterson





--

Andy Pope, Microsoft MVP - Excel
'AJP Excel Information' (http://www.andypope.info)



--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=87527


JLGWhiz

VB Editor and Moving Line Pointer
 
Good tip, Andy. I used the arrow keys to place the insertion marker on a
line and then Ctrl + F9 to jump up, or Ctrl + F8 to jump down. It is
practically as fast as using the mouse.

"Andy Pope" wrote:

Hi,

Perhaps you could use the Keyboard shortcut.
On the line where you want to step to use CTRL+F9

Cheers
Andy

Tim Childs wrote:
Hi

I am editing and debugging code in the editor on a LAPTOP. The problem is
that using the left button touchpad mouse I am not able to drag the yellow
pointer in "step-through" mode. All that happens when I press the left
button is that I get a new break-point. Apart from getting a conventional
mouse, is there a tip or workaround, please?

Many thanks

Tim



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


Tim Childs[_3_]

VB Editor and Moving Line Pointer
 
Hi Andy

Thanks for that - I have made it to work now. sorry it took so long for me
to get the hang of it

Tim

PS I enjoyed the graph sessions you did at the recent Excel User
conference - it was a tour de force!

"Andy Pope" wrote in message
...
Hi Tim,

Did you try the CTRL+F9 keyboard short cut?
If you move the text cursor back up the code you can step back to the line
where the cursor now is and use F8 to step forward again.

Cheers
Andy

Tim Childs wrote:
Hi to all

Many thanks for the suggestions.

However, the thing I am trying to do is drag the yellow cursor typically
up the code and it just does not "work" on the laptop - the step options
are not a complete solution because I often want to drag the yellow point
UP the code to run thru it again, using F8 etc.

Any ideas?

Thanks

Tim

"Dave Peterson" wrote in message
...

Maybe you can use the keyboard.

After you've started stepping through the code, click on Debug on the
toolbar.

You'll see some options with their corresponding keyboard shortcuts.



Tim Childs wrote:

Hi

I am editing and debugging code in the editor on a LAPTOP. The problem
is
that using the left button touchpad mouse I am not able to drag the
yellow
pointer in "step-through" mode. All that happens when I press the left
button is that I get a new break-point. Apart from getting a
conventional
mouse, is there a tip or workaround, please?

Many thanks

Tim

--

Dave Peterson





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info



Tim Childs[_3_]

VB Editor and Moving Line Pointer
 
Hi Chip

Many thanks for the patient explanation which really helped in getting to
grips with the functionality to work. Very neat. It is such a relief to be
able to replicate what I normally manage "without thinking" using the mouse
on the desktop.

Best wishes

Tim

"Chip Pearson" wrote in message
...


When the code is paused a line, use the arrow keys of move the cursor
up to the desired line. Then right-click with the right-click button
(between the right-side ALT and CTRL keys on a normal keyboard --
location differs from one laptop to the next) and choose "Set Next
Statement". This will have the same effect as dragging the yellow
execution line upwards in the code.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Sat, 18 Apr 2009 14:40:56 +0100, "Tim Childs"
wrote:

Hi to all

Many thanks for the suggestions.

However, the thing I am trying to do is drag the yellow cursor typically
up
the code and it just does not "work" on the laptop - the step options are
not a complete solution because I often want to drag the yellow point UP
the
code to run thru it again, using F8 etc.

Any ideas?

Thanks

Tim

"Dave Peterson" wrote in message
...
Maybe you can use the keyboard.

After you've started stepping through the code, click on Debug on the
toolbar.

You'll see some options with their corresponding keyboard shortcuts.



Tim Childs wrote:

Hi

I am editing and debugging code in the editor on a LAPTOP. The problem
is
that using the left button touchpad mouse I am not able to drag the
yellow
pointer in "step-through" mode. All that happens when I press the left
button is that I get a new break-point. Apart from getting a
conventional
mouse, is there a tip or workaround, please?

Many thanks

Tim

--

Dave Peterson




Andy Pope

VB Editor and Moving Line Pointer
 
Thanks for the comments. Glad you enjoyed it.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Tim Childs" wrote in message
...
Hi Andy

Thanks for that - I have made it to work now. sorry it took so long for
me to get the hang of it

Tim

PS I enjoyed the graph sessions you did at the recent Excel User
conference - it was a tour de force!

"Andy Pope" wrote in message
...
Hi Tim,

Did you try the CTRL+F9 keyboard short cut?
If you move the text cursor back up the code you can step back to the
line where the cursor now is and use F8 to step forward again.

Cheers
Andy

Tim Childs wrote:
Hi to all

Many thanks for the suggestions.

However, the thing I am trying to do is drag the yellow cursor typically
up the code and it just does not "work" on the laptop - the step options
are not a complete solution because I often want to drag the yellow
point UP the code to run thru it again, using F8 etc.

Any ideas?

Thanks

Tim

"Dave Peterson" wrote in message
...

Maybe you can use the keyboard.

After you've started stepping through the code, click on Debug on the
toolbar.

You'll see some options with their corresponding keyboard shortcuts.



Tim Childs wrote:

Hi

I am editing and debugging code in the editor on a LAPTOP. The problem
is
that using the left button touchpad mouse I am not able to drag the
yellow
pointer in "step-through" mode. All that happens when I press the left
button is that I get a new break-point. Apart from getting a
conventional
mouse, is there a tip or workaround, please?

Many thanks

Tim

--

Dave Peterson




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info





All times are GMT +1. The time now is 10:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com