How To Assigned "SelectionChange" Event To different Worksheets

G

G

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,
 
B

B Lynn B

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.
 
D

Dave Peterson

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!)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top