automatically switch to the next cell after the type-in of only one digit without entering...

You can not setup Excel that way, but it is possible to assign macros to the number keys to emulate that.

Copy the code into a regular module

Run EnableOneKey, then type a 9 and/or 1

Run DisableOneKey, then type a 9 and/or 1

You have to create the other subs for the number keys 2 to 8 by yourself.

Andreas.

Option Explicit

Sub EnableOneKey()

  Application.OnKey "1", "One"

  Application.OnKey "9", "Nine"

End Sub

Sub DisableOneKey()

  Application.OnKey "1"

  Application.OnKey "9"

End Sub

Sub One()

  ActiveCell = 1

  SwitchToNextCell

End Sub

Sub Nine()

  ActiveCell = 9

  SwitchToNextCell

End Sub

Private Sub SwitchToNextCell()

  Select Case Application.MoveAfterReturnDirection

    Case xlDown

      ActiveCell.Offset(1).Select

    Case xlUp

      ActiveCell.Offset(-1).Select

    Case xlToLeft

      ActiveCell.Offset(, -1).Select

    Case xlToRight

      ActiveCell.Offset(, 1).Select

  End Select

End Sub

Thanks thomas,



my computer is not preloaded with office 2010 so am trying to download it first but can finish the operation. is stoping exactelly at the last step. Now i have uninstall the the run and clkick program so that i can switch to Msi based by running to run singleImage
using the advanced option. After choosing the 64 Bit and waiting for than 1 hour till the download is complete. after that is not giving me any option of entering my product key. am stok and dont know what to do next.

if i posted in this forum is because am leaving in germany now but my deutsh is not yet very good. tkx

Hello Rudolph,

as you can see, on the picture, the document`s name below the documents picture preview is not seen in full(text).

The name of the document is only seen, if, the mouse pointer / finger rolls over the document = tip function.

The point is, if all my personal templates begins with the same document name, i have to roll over all documents by mouse / finger to finde the right one.

Is there a way change the view, to see at glance the name of the document, without to roll over every one?

Thank you.

Best

Yes, it is possible to create dynamic filters for a SharePoint list view that will automatically update the calendar view to show only the items that meet the filter criteria. You can do this by using the Filter option in the list view settings.
To create a dynamic filter for your list view, follow these steps:

1. Open the list in SharePoint and switch to the view you want to filter.
2. Click on the gear icon in the top right corner of the page and select “List settings” from the drop-down menu.
3. Scroll down to the “Views” section and click on the name of the view you want to filter.
4. In the “Filter” section, select “Show items only when the following is true” and set up your filter criteria using the available fields and operators.
5. Click “OK” to save your changes.
   

Once you’ve set up your dynamic filter, the calendar view will automatically update to show only the items that meet your filter criteria. You can change or remove the filter at any time by going back to the list view settings and modifying your filter criteria.

Hi Kyle, (I switch to english because it seems automatic translated)

thanks for your fast support.

As I wrote reparing office 2010 with the original CD didn't.

Installing new may work but is a big effort which I try to avoid, esepecially in the case of outlook and many email accounts.

To find the source of the problem I uninstall the outlook updates KB4011196, KB2760779 and KB2553308 and outlook 2010 runs without problems.

I will take this simple solution as a first approach, but I would be glad about a more sophisticated one without considerable effort for me.

Many thanks and best regards

Jürgen