I'm trying to put in some "AfterUpdate" processing.

Something I Googled advises:

"All you need to do is select the code page for the worksheet in
question, select the drop down at the top left (which should say
'(general)'), pick 'Worksheet' then select the 'Change' member of
the drop down on the right. This will give you the Event sub."

But how to find the "Code page for the worksheet"?

Otherwise, it sounds like the MS Access development environment.

All I see is Tools|Macros - which will get me to a code window,
but that code window lacks the drop down at the top left that
lets me point to "General" or various control names.

What am I missing?
--
PeteCresswell

One way:-

Right click the page tab and view code

Mike

"(PeteCresswell)" wrote:

> I'm trying to put in some "AfterUpdate" processing.
>
> Something I Googled advises:
>
> "All you need to do is select the code page for the worksheet in
> question, select the drop down at the top left (which should say
> '(general)'), pick 'Worksheet' then select the 'Change' member of
> the drop down on the right. This will give you the Event sub."
>
> But how to find the "Code page for the worksheet"?
>
> Otherwise, it sounds like the MS Access development environment.
>
> All I see is Tools|Macros - which will get me to a code window,
> but that code window lacks the drop down at the top left that
> lets me point to "General" or various control names.
>
> What am I missing?
> --
> PeteCresswell
>

On the left side of the code pane [(Use Alt + F11) from your workbook - If
the code pane is not visible - use View from VBA menu -->Project Explorer]
you will find your workbook project - for example, VBAProject (Book1)-->
Below that you will find Microsoft Excel Objects --> Sheet1, Sheet2 etc.

Just double click the Sheet1, which will open the code page for the
correspondig sheet

Here you need to select Worksheet in the first dropdown and the
corresponding event in the next dropdown

If you are looking for workbook event, then you should do the same (double
click on the ThisWorkbook in the project explorer)

Cheers
Shasur


--
http://vbadud.blogspot.com


"(PeteCresswell)" wrote:

> I'm trying to put in some "AfterUpdate" processing.
>
> Something I Googled advises:
>
> "All you need to do is select the code page for the worksheet in
> question, select the drop down at the top left (which should say
> '(general)'), pick 'Worksheet' then select the 'Change' member of
> the drop down on the right. This will give you the Event sub."
>
> But how to find the "Code page for the worksheet"?
>
> Otherwise, it sounds like the MS Access development environment.
>
> All I see is Tools|Macros - which will get me to a code window,
> but that code window lacks the drop down at the top left that
> lets me point to "General" or various control names.
>
> What am I missing?
> --
> PeteCresswell
>

If you right-click worksheet tab at the bottom of the page, you can choose
"View Code" to go to that sheet's code module in the VBA editor. See also
http://www.cpearson.com/excel/codemods.htm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)




"(PeteCresswell)" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'm trying to put in some "AfterUpdate" processing.
>
> Something I Googled advises:
>
> "All you need to do is select the code page for the worksheet in
> question, select the drop down at the top left (which should say
> '(general)'), pick 'Worksheet' then select the 'Change' member of
> the drop down on the right. This will give you the Event sub."
>
> But how to find the "Code page for the worksheet"?
>
> Otherwise, it sounds like the MS Access development environment.
>
> All I see is Tools|Macros - which will get me to a code window,
> but that code window lacks the drop down at the top left that
> lets me point to "General" or various control names.
>
> What am I missing?
> --
> PeteCresswell

Per Shasur:
>[(Use Alt + F11) from your workbook - If
>the code pane is not visible - use View from VBA menu -->Project Explorer]
>you will find your workbook project - for example, VBAProject (Book1)-->
>Below that you will find Microsoft Excel Objects --> Sheet1, Sheet2 etc.

Thanks Shasur, Mike, Chip - I'm on the path to enlightenment
now....

At the risk of turning into a tarbaby on you...

Given that I'm in Worksheet_Change() and I have access to
Target.Address - and the worksheet is *not* using R1C1 notation -
how would I go about identifying various cells relative to
Target.Address.

My immediate interest is in clearing the cell immediately to the
right.

I'm working though a multi-column Validation example where the
validation of column B changes depending on what was selected in
column A - so, in the real world, it would seem necessary to
clear the contents of column B if the user changes column A -
since a different list would then be in effect.

If I were in R1C1 notation, I'd parse Target.Address into R and
C, and then increment C or R depending on where I wanted to go.

--
PeteCresswell