Keyboard shortcut for highlighting cell

[Legacy 232375]

What is the keyboard shortcut for highlighting cell? Can a frequently-performed task be assigned a keyboard shortcut by user? If it is done by VBA, please post the code.

Thanks.

 

[auto.pilot]

You could do this by recording a macro. First click 'Record Macro'. When the window opens, name your macro and also input your desired keystroke in the 'Shortcut key' box. Using the dropdown, you can also choose where you want the macro to be stored, either in the current file or in your personal macro workbook. Click OK then choose your background color. Then click 'Stop Recording'. Now, every time you hold down Ctrl with the keystroke you selected, the background color will change.

 

[asad]

I am new to macro myself but here is a try

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim r As Range
Dim A As Range
Set r = Range(Target.Address)
Set A = Range("A1:AZ200")
If Target.Cells.Count > 1 Then Exit Sub
A.Interior.ColorIndex = xlNone
r.Interior.ColorIndex = 6

End Sub

 

[Legacy 232375]

Wonderful, it worked! So does this mean, I can perform any set of tasks with a single stroke by recording them into a macro?
And Why is that I'm not able to undo this once I used the macro?
Thank You.

 

[Michael M]

Once a macro has been run the Undo stack is cleared.