Excel VBA for highlighting Cells

[KurmallyIsmael]

Hi,
Please help with a VBA code to display the highlighting of cells coler pop up and choosing our color to apply to the cells (by pressing a shortcut like ctrl+h) instead of doing same from the ribbon.

So, for e.g, if I am on Cell A6 and I want to highlight this cell with Purple color, I want to do same just by pressing ctrl+h and then choosing the purple color instead of choosing it from the ribbon.

Grateful for your help...EnjoyExcel

 

[Cubist]

Have you tried F4?

 

[Peter_SSs]

Try Alt+h+h

 

[KurmallyIsmael]

Have you tried F4?

Hi,
Thanks for reply and help.

This just repeats last action or locks rows and/or columns. So, does not accomplish what I need.

 

[KurmallyIsmael]

Try Alt+h+h

Hi,
Thanks for reply and help.

Would like the color window to pop up itself seperately from the window. Something, like a find and replace window.

 

[jolivanes]

Sub Get_Colors()
    Application.Dialogs(161).Show
End Sub

Developer - Macros (Select "Get Colors") - Options - Put an "h" in the little window to the right of "Crtl+"

 

[Peter_SSs]

Would like the color window to pop up itself seperately from the window

Ctrl+1 F F

 

[KurmallyIsmael]

Ctrl+1 F F

Hi
Thanks
I Would like for a quicker way. I tried this one but would like a method that works more quickly. But, thanks for your help...

 

[Peter_SSs]

I Would like for a quicker way.

Apply a shortcut key combo to this macro

Sub Format_Color()
  Application.SendKeys ("^1AFF")
End Sub

 

[KurmallyIsmael]

Sub Get_Colors()
    Application.Dialogs(161).Show
End Sub

Developer - Macros (Select "Get Colors") - Options - Put an "h" in the little window to the right of "Crtl+"

Hi,
I tried it but it gave error saying Run-Time error "1004"
Any idea?