Nikhil,
insert a module, and paste this code
Sub Auto_Open()
Application.OnKey "+g", "'RunMe ""g""'"
Application.OnKey "+d", "'RunMe ""d""'"
Application.OnKey "+a", "'RunMe ""a""'"
Application.OnKey "+f", "'RunMe ""f""'"
Application.OnKey "+r", "'RunMe ""r""'"
End Sub
Sub Auto_Close()
Application.OnKey "+g"
Application.OnKey "+d"
Application.OnKey "+a"
Application.OnKey "+f"
Application.OnKey "+r"
End Sub
Sub RunMe(strKey As String)
Select Case strKey
Case "d"
Selection.Value = "Dividend"
Case "g"
Selection.Value = "Growth"
Case "a"
Selection.Value = "Additional"
Case "f"
Selection.Value = "Fresh"
Case Else
Selection.Value = "Dividend Reinvestment"
End Select
End Sub
, then reopen the saved file.
Now select any cells and press SHIFT+d to write "Dividend" in the selected
cells, similarly for other words. Note that you cannot use ALT
Regards,
Sam Mathai Chacko (GL)
On Tue, Sep 13, 2011 at 10:50 PM, Nikhil Shah <nikhil201...@gmail.com>wrote:
> Dear All,
>
> As per your E-mail I am sending here with an Excel Sheet Attachment in
> which I have shown what exactly I want.
> ( see column No.... ' O ')..
>
> Thanks.
>
> Nikhil
>
>
> On Tue, Sep 13, 2011 at 7:47 PM, dguillett1 <dguille...@gmail.com> wrote:
>
>> Perhaps you could simply use a DATA VALIDATION list to select the item(
>> tied to a CHANGE_EVENT macro. Send me your file with a clear explanation and
>> before/after examples
>>
>>
>> *From:* Nikhil Shah <nikhil201...@gmail.com>
>> *Sent:* Tuesday, September 13, 2011 9:02 AM
>> *To:* excel-macros@googlegroups.com
>> *Cc:* noorain.ans...@gmail.com
>> *Subject:* Re: $$Excel-Macros$$ VBA Code For Repeating Of Text
>>
>> Dear Noorain
>>
>> I have recd your
>>
>> Actually I forgot to mention that the excel which I am using right now is
>> Office 2003.So I can not use the excel sheet which you have sent for my
>> help.
>>
>> Can you please send me the shore keys with Macro. B'caus to my
>> understanding as per your sheet of command button I will have to create each
>> command button for every text. If they are more in numbers then it will be
>> difficult to handle the file.
>>
>> So if possible can you make a VBA Code List to avoid the repeating of
>> typing the same text.
>>
>> Thanks for the help in advance.
>>
>> Nikhil
>>
>>
>> On Tue, Sep 13, 2011 at 2:16 PM, NOORAIN ANSARI <noorain.ans...@gmail.com
>> > wrote:
>>
>>> Dear Nikhil,
>>>
>>> Please see attached sheet.............
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>>
>>> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>>>
>>> On Tue, Sep 13, 2011 at 11:32 AM, Nikhil Shah
>>> <nikhil201...@gmail.com>wrote:
>>>
>>>> Dear all,
>>>>
>>>> I want Help for creating the VBA Codes for Repeating of Text in my Excel
>>>> sheet..
>>>>
>>>> *Problem :*
>>>>
>>>> I have made excel sheet in Columns.In which I have some texts which
>>>> are likely to repeat in my sheet frequently. So please help me to make
>>>> proper Hot Keys to make my work fast and easy.
>>>>
>>>> Ex : Dividend, Growth , Fresh, Additional.....etc, there are suppose to
>>>> be more then 25 Text which are repeating frequently.
>>>>
>>>> Suppose If I have to type dividend repeatedly then I press only Alt+d
>>>> which means it will be automatically typed dividend any time and so on for
>>>> other words also like Growth, Fresh..... etc. and for that I want VBA Code.
>>>>
>>>> Thanks for the help in advance.
>>>>
>>>> Nikhil
>>>>
>>>> --
>>>>
>>>> ----------------------------------------------------------------------------------
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>
>>>
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Sam Mathai Chacko
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
