Prev: Assign faceid to image on userform
Next: Creating several TextBoxes (Shapes) with cell references as contents
From: Marge on 17 Dec 2009 11:46
Is it possible with VBA the make a sheet select only one cell at a
time when you drag the cursor around the sheet instead of the normal
function of selecting a range?
From: Rick Rothstein on 17 Dec 2009 11:53
You can do it with VBA code. Right click the tab at the bottom of the
worksheet you want to have this functionality, select View Code from the
popup menu that appears and copy/paste this code into the code window that
opened up...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target(1).Select
End Sub

Now, go back to that worksheet and try to select multiple cells.

--
Rick (MVP - Excel)


"Marge" <marge1963(a)googlemail.com> wrote in message
news:73269891-4876-4dfc-81a6-52784209a752(a)d21g2000yqn.googlegroups.com...
> Is it possible with VBA the make a sheet select only one cell at a
> time when you drag the cursor around the sheet instead of the normal
> function of selecting a range?

From: Marge on 17 Dec 2009 13:34
Thanks Rick,

That does do what I asked :o)

not quite what I was hoping for though, not sure if it would be
possible, instead of still selecting the upper left cell I want each
cell under the cursor as it moves to be selected individually.

On 17 Dec, 16:53, "Rick Rothstein"
<rick.newsNO.S...(a)NO.SPAMverizon.net> wrote:
> You can do it with VBA code. Right click the tab at the bottom of the
> worksheet you want to have this functionality, select View Code from the
> popup menu that appears and copy/paste this code into the code window that
> opened up...
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>   Target(1).Select
> End Sub
>
> Now, go back to that worksheet and try to select multiple cells.
>
> --
> Rick (MVP - Excel)
>
> "Marge" <marge1...(a)googlemail.com> wrote in message
>
> news:73269891-4876-4dfc-81a6-52784209a752(a)d21g2000yqn.googlegroups.com...
>
>
>
> > Is it possible with VBA the make a sheet select only one cell at a
> > time when you drag the cursor around the sheet instead of the normal
> > function of selecting a range?- Hide quoted text -
>
> - Show quoted text -

From: Neptune Dinosaur on 17 Dec 2009 23:41
Not sure that this is what you mean, but you can select multiple
discontiguous cells (and/or groups of cells) if you hold down <Ctrl> while
you move about the sheet selecting.

--
Time is just the thing that keeps everything from happening all at once


"Marge" wrote:

> Is it possible with VBA the make a sheet select only one cell at a
> time when you drag the cursor around the sheet instead of the normal
> function of selecting a range?
> .
>
From: Marge on 20 Dec 2009 08:37
Thanks for the reply, but no,

when I press the mouse button and move in a diagonal line I want to
select each individual cell momentarily in that diagonal line not
stretch to a group(larger square)

If there was a way to make excel just select the cell under the cursor
as you move the mouse that would do just what I need.



On 18 Dec, 04:41, Neptune Dinosaur <wor...(a)halfchopper.com> wrote:
> Not sure that this is what you mean, but you can select multiple
> discontiguous cells (and/or groups of cells) if you hold down <Ctrl> while
> you move about the sheet selecting.
>
> --
> Time is just the thing that keeps everything from happening all at once
>
>
>
> "Marge" wrote:
> > Is it possible with VBA the make a sheet select only one cell at a
> > time when you drag the cursor around the sheet instead of the normal
> > function of selecting a range?
> > .- Hide quoted text -
>
> - Show quoted text -

 | 
Pages: 1
Prev: Assign faceid to image on userform
Next: Creating several TextBoxes (Shapes) with cell references as contents