Not Enough ShortCut Keys

**BigMcBen** · 01-25-2012, 05:01 PM

I have an spreadsheet where the same cells on sheet A are selected each night but are pasted into different cells on sheet B referring to Monday to Friday. What I've done is a macro for each day but there are only four letters available with the CTRL key, so I can't use a shortcut for Friday. Any ideas?

**Mordred** · 01-25-2012, 05:06 PM

Start using buttons instead of shortcut keys.

**tigeravatar** · 01-25-2012, 05:08 PM

could use a capital letter that would mean ctrl+shift+letter
so ctrl+q would be a macro
and ctrl+shift+q would be a different macro

**tigeravatar** · 01-25-2012, 05:10 PM

As a side note, I do agree with Mordred on this. Buttons are visual and there's nothing to remember. If you forget a shortcut key, or are explaining to someone new and they have to learn all of them all at once, it makes it more difficult to easily run the macro.

**Mordred** · 01-25-2012, 05:13 PM

Originally Posted by tigeravatar

could use a capital letter that would mean ctrl+shift+letter
so ctrl+q would be a macro
and ctrl+shift+q would be a different macro

I never been to sure on this approach as I have used it once with my supervisor and everytime he did an update (monthly) he would ask me what the process was. Once I started using buttons I have never had those kinds of user problems.

**Mordred** · 01-25-2012, 05:13 PM

Originally Posted by tigeravatar

As a side note, I do agree with Mordred on this. Buttons are visual and there's nothing to remember. If you forget a shortcut key, or are explaining to someone new and they have to learn all of them all at once, it makes it more difficult to easily run the macro.

LoL, didn't see this!

**tigeravatar** · 01-25-2012, 05:30 PM

that's cuz i'm sneaky, hehe

**BigMcBen** · 01-25-2012, 07:20 PM

Thanks for all the replies. I'm not sure what you mean by using buttons though. Still a real newbie when it comes to macros in Excel, hence the reason this site is so useful.

**BigMcBen** · 01-25-2012, 07:21 PM

Originally Posted by tigeravatar

could use a capital letter that would mean ctrl+shift+letter
so ctrl+q would be a macro
and ctrl+shift+q would be a different macro

I did think of this, but when I tried the computer made a funny beep and nothing happened :-(

**Mordred** · 01-26-2012, 12:32 AM

I made up a workbook with 3 different examples of button usage. If you have any questions, post them.

ButtonsBook.xlsm

**Marcol** · 01-26-2012, 05:53 AM

Instead of buttons you could consider the VBa Worksheet SelectionChange event to make cells simulate buttons.

**BigMcBen** · 01-26-2012, 06:33 PM

Took me a wee while to work out how to find the 'button' as my friend was using 2003, but that's it sorted and working a treat. Thanks for all of the help.