'Move the question text from column B to target
'Update the global "lastClicked" variable LastClicked.Value = lastClicked.Offset(, 2).Value 'Copy the holder value from column C back to Column A
Private Sub Worksheet_SelectionChange(ByVal Target As Range) In that code window place the following: 'Global Variable to hold the last column A cell that was clicked into In your VBE, double click the worksheet where this event is taking place in the VBAProject pane. To learn more about Event Macros (worksheet code), see:īesides using Comments you could use a VBA subroutine to do this based on the worksheet's SelectionChange event. To learn more about macros in general, see: If you are using a version of Excel later then 2003, you must save If you save the workbook, the macro will be saved with it. If you have any concerns, first try it on a trial worksheet. paste the stuff in and close the VBE window.select View Code - this brings up a VBE window.
Excel hide overflow text install#
If Intersect(A1, ActiveCell) Is Nothing ThenĪ1.Characters(Start:=1, Length:=l).Font.ColorIndex = 1Ī1.Characters(Start:=5, Length:=l).Font.ColorIndex = 2Ī1.Characters(Start:=1, Length:=4).Font.ColorIndex = 2Īnd if you click off the cell, you will see:īecause it is worksheet code, it is very easy to install and automatic to use: First enter this in the cell: IMP1What is the meaning of life ?Īnd then place the following Event Macro in the worksheet code area: Private Sub Worksheet_SelectionChange(ByVal Target As Range) This is specifically for the single cell A1, but can be expanded to process all the cells in column A.
0 kommentar(er)
