how to use keyboard in this case

B

bhaveshchauhan

Without using the mouse how can we copy the value in all the cell..


forx exa..

if we write Jan in the celll then without using the mouse when we g
down with the help of keyboard it should go like jan , feb and soon..

kindly help me out

thank
 
R

Rollin_Again

You will need to add some VBA code to the Workbook_SheetSelectionChang
Event. When the selected cell changes your code will be fired. Al
you need to do is add the logic to add the values you want to the othe
cells. I am still a little confused as to what you want to do. Do yo
want this code to work with any month that you enter in a cell? B
more specific and I'll try to help you a little more.



Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVa
Target As Excel.Range)

'Add your Logic Here

End Sub




Rolli
 
B

Bernard Liengme

Sounds like homework but here goes:
Type Jan
Hold Shift and use down arrow to select 12 cells
Use Alt+E to open the Edit menu
Use down arrow to move to Fill; tap Enter key to open dialog box
Experiment with Tab and Enter to specify Autofill

A totally rodent-free experience!

Best wishes
 
Top