i need shortcut for filling multiple words in multiple cell

[vengatvj]

"if i type "vv" in A1 CELL, THEN it should be change "invoice" in A1 cell, in b1 cell fill automatically "999" and c1 cell fill "cash back offer"

how to set ?

just type two or three character in one cell, and fill assigned words in 3 cells, its just like auto-correct options, but fill in multiple cell

[xladept]

You could use the Worksheet_Change event and key it to Column A.

[vengatvj]

how to use Worksheet_Change ? could u give me sample file relate to my needs

[xladept]

Here's one:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Save your Workbook As Macro-Enabled

Click on the appropriate sheet

Type "Option Explicit" then paste the code under it

And, you should be ready to go

[vengatvj]

boss i tried it, not working,, may be am wrong, see attached file,

[xladept]

Hi Vengatvj,

Here's your file with the code in the appropriate sheet module (Sheet1).

I had forgotten to add an End if - so, if you tried it the right way and it didn't work, I apologize.
last try.xlsm

[vengatvj]

super buddy, but its working only in A Column, i want work in entire sheet, i need to fill wherever i want, how to modify just give me one more

[xladept]

Just don't restrict it to the "A" column:

Please Login or Register  to view this content.

[vengatvj]

very thanks a lot my dear friend, here after i can work in all computers. before i use only one computer, im using auto-correct options, to do above the function.. now you guide me a new way, many thanks buddy..

[xladept]

Hi Vengatvj,

You might also want to consider using a "Hotkey" - you can record macros to be triggered by a key combination

[vengatvj]

Oh.... if u have time let me know more info am new to macro

[xladept]

You can record any key fr Control + Shift + v then you can add the code:



If you've added your Developer Tab to the ribbon (you ought to do that) then
Developer - Record New Macro - V_Macro

Please Login or Register  to view this content.

OK - or something like that.

Here :last try.xlsm

[vengatvj]

ya yah... i will make this type of shorcut for other use, am going to use make shortcut as i told , all my shortcut relate to my words, example if i type A1, then display vodafone value 199, if i type A2 then display vodafone value 299, if i type A5 then display Vodafone value 599,

i have many words to type in my office excel, so its right way to make shortcut relate to my words..
now i got two more words to fill in multiple cells, all credits to you. thank dear friend, i dont have any questions to ask more.. just seeing others threads..

[vengatvj]

Please Login or Register  to view this content.

hi, recently i met a debug error, when i select particular row column and make it delete. you just try yourself and tell me what to do,

[vengatvj]

Hi Friends, The above Program is very Important to me. I need to make many shortcut for my daily use, The program is working as well, but The only problem is it gives debug error when i try to delete multiple row and column data. How to solve the problem?

[xladept]

Hi Vengatvj,

If you're going to delete, then you should turn off the events:

Please Login or Register  to view this content.

Then, of course, you'd need to reinstate the events:

Please Login or Register  to view this content.

Or you could make yourself a toggle switch:

Please Login or Register  to view this content.

[vengatvj]

i don't know how to add your switch code, can you give me again full program with toggle switch.. Please give me sample file with code. i tried it, unable to make myself..

i am going to make shortcut more than 30 words, could you give me sample program for three shortcuts? should i change event every time? totally i am blind about vba. give me right way to modify shortcut and add more than, also allow me to delete some column row data.

[xladept]

Hi Vengatvj,

I put the toggle on a hotkey - to use it, just hit Ctrl+Shift+E - If you wanted a button for it you can just put up a button and give it this code in the click-event:

Please Login or Register  to view this content.

(Since you're using a ribbon-impacted version of Excel, automatically adding a button to the tooolbar doesn't leave it immediately accessible anymore.)last try TE.xlsm

[vengatvj]

Wow.. Thank you so much buddy, its my daily use program, many many thanks .. you save my time

[xladept]

You're welcome!

[xladept]

Hi Vengatvj,

I put a button at the top center - code is in the module. And, I wrote the code for its click event - code is in the sheet. You needn't run the code for the button placement again on this sheet last try TE.xlsm

[vengatvj]

WOW WOW.. very thanks a lot.. just now i saw your reply. Sorry. Its good. Thank you so much

One small request. I want set this Button always on top. I don't want move this button. if I down cell then this button hide. also hide when i go to right side.
I want fix permanently this button in top. how to set?

[xladept]

Hi Vengatvj,


I haven't figured out how to make that button free floating - but, while I ponder it, you can freeze panes:

Select A4 - Click on the View icon and choose freeze panes.