Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 139
Default "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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
VBA code store address with areas separated with "," and I need it sometimes with ";" instead tskogstrom Excel Programming 2 June 17th 07 04:14 AM
Code to concat "Jo Smith" and "Ja Smith" if there are multiple "J Smiths" Arnold[_3_] Excel Programming 6 October 22nd 06 11:24 AM
Can you "duplicate" "copy" listboxes and code to multiple cells? HotRod Excel Programming 1 September 1st 04 05:03 PM
Looking for VB code to test for "RING" , "BUSY" disconnects or other signals BruceJ[_2_] Excel Programming 3 November 20th 03 01:55 AM


All times are GMT +1. The time now is 10:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"