Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,562
- Office Version
- 365
- 2016
- Platform
- Windows
I'm going to try to explain this the best I can with my limited vba vocabulary.
I have a worksheet that gets populated dynamically through VBA. The number of rows of data are always changing with each query from the user, but the presentation format of the data is always consistent. The data is presented over 8 columns from column A:H. Each cell in each dynamic range (column & number of rows) has a list validation. What I am trying to accomplish is that when a user changes the value in a particular cell within that range (column) a procedure is executed. Each column of values will have a unique procedure called.
So, it would be a worksheet change event. I already have one, but it's a static cell that is active all the time. I don't know though how to add these events to the worksheet change when they are dynamic and created from other code. I can't code it (to my knowledge) into the worksheet change module until I know the range of cells to check). The ranges are in place, now I have to ensure the worksheet change code is watching for these changes in each respective column.
I hope I make enough sense that someone can provide some direction.
I have a worksheet that gets populated dynamically through VBA. The number of rows of data are always changing with each query from the user, but the presentation format of the data is always consistent. The data is presented over 8 columns from column A:H. Each cell in each dynamic range (column & number of rows) has a list validation. What I am trying to accomplish is that when a user changes the value in a particular cell within that range (column) a procedure is executed. Each column of values will have a unique procedure called.
So, it would be a worksheet change event. I already have one, but it's a static cell that is active all the time. I don't know though how to add these events to the worksheet change when they are dynamic and created from other code. I can't code it (to my knowledge) into the worksheet change module until I know the range of cells to check). The ranges are in place, now I have to ensure the worksheet change code is watching for these changes in each respective column.
I hope I make enough sense that someone can provide some direction.