deyken
01-17-2012, 11:35 PM
Hi All,
I have a formatted worksheet with a number of rows with categorised information in these rows (accross several cols). In Col "A" I have a little 'code' and I want the row number to change based on this 'code' as entered by the user. That is, I want the entire row to Cut/Paste to a different location on the same Sheet, based on the category value typed into Columb "A". This Sub must fire every time the user clicks out of the cell.
As such, I want to know if there is some sort of Cell_OnExit() routine I can call to make this happen every the user clicks out of Cell(x, "A")?
I have a formatted worksheet with a number of rows with categorised information in these rows (accross several cols). In Col "A" I have a little 'code' and I want the row number to change based on this 'code' as entered by the user. That is, I want the entire row to Cut/Paste to a different location on the same Sheet, based on the category value typed into Columb "A". This Sub must fire every time the user clicks out of the cell.
As such, I want to know if there is some sort of Cell_OnExit() routine I can call to make this happen every the user clicks out of Cell(x, "A")?