Prev: Identify excel file on taskbar
Next: Array - retrieve certain amount of recods for query
From: G on 27 May 2010 18:00
I was able to assign To WorkSheet the SelectionChange event.

It turns out that it was my 2nd Sheet. How do I Add Selectionchange to my
1st worksheet. ???

Thank You,


From: Don Guillett on 27 May 2010 19:16
cut/paste

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"G" <G(a)discussions.microsoft.com> wrote in message
news:870C97F9-3951-4FDE-8C84-9F4DE039DB28(a)microsoft.com...
>I was able to assign To WorkSheet the SelectionChange event.
>
> It turns out that it was my 2nd Sheet. How do I Add Selectionchange to
> my
> 1st worksheet. ???
>
> Thank You,
>
>

From: B Lynn B on 27 May 2010 19:46
In the VB editor window, there should be a frame on the left hand side that
displays the project objects. If it's not showing, Ctrl-R will bring it up.
You'll see the name of your workbook as one of the VBAProject folder items.
Under that (when uncolapsed), is a folder titled Microsof Excel Objects,
under which you find the sheet and workbook objects in your file.

Double click the sheet where you want to add a Selection_Change event to
open its code window. With that frame's upper left dropdown, select
Worksheet. With the upper right dropdown, select SelectionChange.

"G" wrote:

> I was able to assign To WorkSheet the SelectionChange event.
>
> It turns out that it was my 2nd Sheet. How do I Add Selectionchange to my
> 1st worksheet. ???
>
> Thank You,
>
>
From: Dave Peterson on 27 May 2010 20:04
You may be able to use the Workbook_SheetSelectionChange (in the ThisWorkbook
module).

Or even put a common routine in a general module that each
worksheet_selectionchange event calls (passing nice parms).

(If it's a small procedure and I only need for a couple of sheets, I'd follow
Don's suggestion!)

G wrote:
>
> I was able to assign To WorkSheet the SelectionChange event.
>
> It turns out that it was my 2nd Sheet. How do I Add Selectionchange to my
> 1st worksheet. ???
>
> Thank You,

--

Dave Peterson
 | 
Pages: 1
Prev: Identify excel file on taskbar
Next: Array - retrieve certain amount of recods for query