Excel-VBA - Zeiteingabe mit der Maus in Excel

Time entry in Android using the dial is comfortable. This article presents the Excel-Version from QRS, llc

Why?

As mentioned in the article on Date entry using the mouse, the goal of the present article is the input of a time using the mouse without the use of ActiveX or Form controls. The idea of using a 12-hour dial originates from the Android calender app. Toggling between 12-hour sets requires clicking the central cell. To minimize the size of the dial range, a simplified minute entry was designed allowing for five-minute intervals in two cklicks..

Settings

Other than the output range for the dial, an hour can be specified as the last hour in the night dial. The inital 12-hour mode may also be set. No Auto-OK is provided for time input.

Demo video

The vdeo shows calling of the pop-Up dial by clicking on a cell-button, toggling of the 12-hour set, selection of an hour and quarter-hour. Input is validated by clicking on the green OK ("/") cell.

Comments and Responses

×

Name is required!

Enter valid name

Valid email is required!

Enter valid email address

Comment is required!

Comments :

  • user
    pGbMBiRY 21/11/2024 At 01:01
  • user
    jIRYgkWOMxKPVl 15/11/2024 At 07:50
  • user
    RKZwPsqYd 09/11/2024 At 14:24
Top