set code as short cut keys

[sam1128033]

Pls i want to get some detail in file -


i have a pricing code example code - wo/st-kdi i want to giv
this to short cut key 1M
code - wo/st-kde i want to give this to short cut 2

now this code will go on because the pricing will change - i want t
save this code to excel file for example - if i press 1M - the code
wo/st-kdi ) will appear in colum automatic is there any way to writ
program in excel file like this way



i will be very appreciate if you could guide me



Regards
sa

 

[Simon Lloyd]

You would be bette off having a command button on your toolbar whic
pops up a userform with a dropdown box for the codes (you can have
dynamic named range for the list) and a short description, does tha
sound ok to you

Pls i want to get some detail in excel file -


i have a pricing code example code - wo/st-kdi i want to give this t
short cut key 1M
code - wo/st-kde i want to give this to short cut 2

now this code will go on because the pricing will change - i want t
save this code to excel file for example - if i press 1M - the code
wo/st-kdi ) will appear in colum automatic is there any way to writ
program in excel file like this way



i will be very appreciate if you could guide me



Regard
sa

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[Simon Lloyd]

Sam, i just knocked up a quick example

+-------------------------------------------------------------------
|Filename: Populate codes example.xls
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=264
+-------------------------------------------------------------------

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[sam1128033]

Thanks simon.,

yes but i have almost 8000 codes does it work and when i press the cod
could it will come to the excel columns automaticially.

i am little new to excel i want to set my own code like this

if i type 1m - it will automaticially come like this - uw/m/dd/oi/o
if i type 22m - it will automaticially come like this - uw/uu/dd/oi/o
it will go to thousands

i will explain to you where 22m is equal to uu so when i press the ke
in keyboard i only have to press 22m - answer will come - uw/uu/dd/oi/o
like this way it will easy for me to quote the prices to customer i
confidence way.

Pls guide me in this solution

Regards
sam



Yes but from the list i ( have to choose dynamic named ) i want to giv
my own code it will be very easy me to make a price list.

 

[Simon Lloyd]

Sam, i gave a worked example in that attachment with comments, if you
want to make a post in the members only forum and add a sample workbook
i can help you directly with that.

You said you have 8000 codes how on earth would you have remembered
shortcut keys to them all if that was possible

Thanks simon.,

yes but i have almost 8000 codes does it work and when i press the code
could it will come to the excel columns automaticially.

i am little new to excel i want to set my own code like this

if i type 1m - it will automaticially come like this - uw/m/dd/oi/o
if i type 22m - it will automaticially come like this - uw/uu/dd/oi/o
it will go to thousands

i will explain to you where 22m is equal to uu so when i press the key
in keyboard i only have to press 22m - answer will come - uw/uu/dd/oi/o
like this way it will easy for me to quote the prices to customer in
confidence way.

Pls guide me in this solution

Regards
sam



Yes but from the list i ( have to choose dynamic named ) i want to give
my own code it will be very easy me to make a price list.




--- Automerged consecutive post before response ---
Yes simon thanks you very much for your support could you tell me how
to set up this command -

which i click on the bar botton which u send me something come like
this -

Private Sub CommandButton1_Click()
UserForm1.Show
End Sub


pls guide me how to write this program

Thanks for your great help

Regards
sam




Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub



That's what i am looking for

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)

 

[sam1128033]

Sam, i gave a worked example in that attachment with comments, if yo
want to make a post in the members only forum and add a sample workboo
i can help you directly with that.

You said you have 8000 codes how on earth would you have remembere
shortcut keys to them all if that was possible

simon i understand what you said pls find below detail

i u s t y o n g a k m
1 2 3 4 5 6 7 8 9 0 .

for example - if i quote to custmer price imik then my shor
key will be
1.10m

if i quote to custmer price ikk then my code ke
will be
100m


in that way you will not forget any short key - it's like math but th
answer will come to letters.

i hope you understand

Regards
sa