General Advice - use of Ctrl key sequences

[Sparkle99]

Hi,
I am generating an XLSM file to send to users that will allow them to enter various values.
I want them to be able to use simple Ctrl key sequence to do various activities on the file (mostly to auto-fill some cells).

Currently the file contains macros that are invoked by Ctrl-e, Ctrl-j, Ctrl-l & Ctrl-m.
I chose these as I don't believe they are used (or almost never) in Excel 2007.

But the sequence of e, j, l, m is not intuitive.
I don't want to use Ctrl-a, Ctrl-b, Ctrl-c... for obvious reasons.

Q - Is it possible to use Ctrl-1, Ctrl-2 etc.. ?

Otherwise, any advice to impart ? Suggestions as to how to make user-invoked macros easy to run in a generated file.

Thanks in advance for your help.

 

[doofusboy]

Have you considered using buttons?

 

[Sparkle99]

Yes to buttons, but the nature of the source sheet means that I would need to copy/paste the button objects onto the sheet with code.
The buttons could be on another sheet no problem.

For aesthetic reasons (never the best, I know !) I would like to avoid buttons.

 

[doofusboy]

How about using cells on the source sheet to act as buttons and then using Worksheet_SelectionChange to call the macros based on which cell is chosen?

 

[prajul89]

use Ctrl+Shift+a, Ctrl+Shift+b, Ctrl+Shift+c and so on.............

 

[Sparkle99]

use Ctrl+Shift+a, Ctrl+Shift+b, Ctrl+Shift+c and so on.............

Are these not used ?
Pardon me for being dim here.

So, Ctrl+a is different to Ctrl+A ?
That what I assume Ctrl+Shift+a would be.

If so, then this does what I'm after.

 

[prajul89]

Are these not used ?
Pardon me for being dim here.

So, Ctrl+a is different to Ctrl+A ?
That what I assume Ctrl+Shift+a would be.

If so, then this does what I'm after.

yeap Ctrl+a and Ctrl+A are different.
go ahead you are in the right path.

 

[Sparkle99]

Thanks for the help all.