Excel VBA: Keyboad shortcut to scroll through formatting

Anthony · January 15th, 2010, 12:57 am

HiI used to have some VBA code that when you pressed a keyboard shortcut it would scroll through various formats (date, number, percentage etc) on the selected range of cells. It was very useful, does anyone have something like this to hand?many thanks

sjoo · January 18th, 2010, 2:17 am

Hi the short key as I know is Ctrl+1 that shows the dialogbox of the cell format. I'm wondering what your vba is. In addition, Ctrl+Tab enables you navigate opened workbooks.Bye

jpsnj · January 19th, 2010, 8:29 pm

Ctrl/Shift 1,Ctrl/Shift 2,Ctrl/Shift 3,Ctrl/Shift 4,Ctrl/Shift 5,Ctrl/Shift 6 will provide 6 different number formats for a selected cell.