Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My pointer no longer changes when moving around the worksheet | Excel Discussion (Misc queries) | |||
need to change num key pad from moving the mouse pointer | Excel Worksheet Functions | |||
moving mouse pointer | Excel Programming | |||
moving mouse pointer | Excel Programming | |||
moving the cell pointer after hitting enter | Excel Programming |