ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Worksheet_Change Still Not Executing.... (https://www.excelbanter.com/excel-programming/308861-re-worksheet_change-still-not-executing.html)

[email protected]

Worksheet_Change Still Not Executing....
 
The purpose of the code is to
1) identify if an entry has been made to a specific region of a
worksheet - in this case, a six columned area.
2) determine the location of the cell cell selected - and based on the
column that that data comes from,
look at the other 5 columns within this 6 columned area - within the
same row and determine what the values of the other 5 columns, same
row.

For instance, if the cell selectes is in column a, find out the values
in column b-e, same row
If cell selected is in column b, find out the value in column a, c-e,
same row
If cell selected in in column c, find out the values in column a-b,
d-e, same row
etc.

Eventually, i will be passing these values to various functions that
will validate the entry being made based on the values.



All times are GMT +1. The time now is 04:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com