Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Code Page" ??
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Code Page" ??
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Code Page" ??
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)" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Code Page" ??
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
VBA code store address with areas separated with "," and I need it sometimes with ";" instead | Excel Programming | |||
Code to concat "Jo Smith" and "Ja Smith" if there are multiple "J Smiths" | Excel Programming | |||
Can you "duplicate" "copy" listboxes and code to multiple cells? | Excel Programming | |||
Looking for VB code to test for "RING" , "BUSY" disconnects or other signals | Excel Programming |