Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,489
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,489
Default 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
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default 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



  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,489
Default 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
  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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


  #10   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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



  #11   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default 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

  #12   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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


  #13   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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



  #14   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,489
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
My pointer no longer changes when moving around the worksheet josh8176 Excel Discussion (Misc queries) 3 June 1st 06 07:51 PM
need to change num key pad from moving the mouse pointer RANDY Excel Worksheet Functions 1 December 12th 05 10:36 PM
moving mouse pointer nath Excel Programming 1 August 16th 04 08:36 PM
moving mouse pointer nath Excel Programming 0 August 16th 04 05:27 PM
moving the cell pointer after hitting enter mporter501 Excel Programming 0 April 7th 04 07:36 PM


All times are GMT +1. The time now is 09:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"