DEBLACKJACKAL
New Member
Regards to all.
I have designed a User form which I hope to present to my manager on how we can integrate a user form with a worksheet ledger to facilitate efficient data entry of staff employee utility payments.
There are two worksheets: Sheet1 is designed for SERVICE FEE payments. Sheet2 is designed for FUEL FEE payments. In both ledger sheets the staff names are listed in column in A. ID codes for each staff employee are listed in column B. Dates are listed row wise from E1 to R1 in this case from January 1st 2021 to Jan 16th 2021.
Upon loading the user form, the operator enters ID code by directly typing into or selecting the staff ID code from the combo list. Provided an existing staff ID code is entered or selected, the corresponding or matching staff member name automatically appears in the Name box. Next the user selects payment type either SERVICE FEE or FUEL FEE. User proceeds to enter amount service fee and then clicks at the date box and from the displayed calendar user can now select the appropriate month and date within the current year. Please note that in my example dates are limited from January 1st to January to 16th January 2021. When Enter Key is clicked the amount paid is entered into intersecting cell of the Name/ID row and Date Column.
The user form works well but with one major point of concern. When one enters a none existing ID into the combo box it generates an error. I am seeking for assistance on how can I trap this error and may be generate a message box that states for example “None Existent ID. Please Reenter.”
I have designed a User form which I hope to present to my manager on how we can integrate a user form with a worksheet ledger to facilitate efficient data entry of staff employee utility payments.
There are two worksheets: Sheet1 is designed for SERVICE FEE payments. Sheet2 is designed for FUEL FEE payments. In both ledger sheets the staff names are listed in column in A. ID codes for each staff employee are listed in column B. Dates are listed row wise from E1 to R1 in this case from January 1st 2021 to Jan 16th 2021.
Upon loading the user form, the operator enters ID code by directly typing into or selecting the staff ID code from the combo list. Provided an existing staff ID code is entered or selected, the corresponding or matching staff member name automatically appears in the Name box. Next the user selects payment type either SERVICE FEE or FUEL FEE. User proceeds to enter amount service fee and then clicks at the date box and from the displayed calendar user can now select the appropriate month and date within the current year. Please note that in my example dates are limited from January 1st to January to 16th January 2021. When Enter Key is clicked the amount paid is entered into intersecting cell of the Name/ID row and Date Column.
The user form works well but with one major point of concern. When one enters a none existing ID into the combo box it generates an error. I am seeking for assistance on how can I trap this error and may be generate a message box that states for example “None Existent ID. Please Reenter.”