PDA

View Full Version : VBA Coding Related to Data Entry Form



exlove
02-24-2019, 09:41 AM
Dear All2380123801

Please find attached file and help me to resolve following issues. Excel version 2010

username - admin
password - admin

1) In Add Vehicle Form Contact Number Text Box should not allow value less than or greater than 10 Digits.
2) In Add New Vehicle Form Only Date Selection option should appear in following Text Boxes
Insurance date, MH Tax Date, NH Permit Date , Passing Date
3) When Date will be saved in Vehicle Sheet then it should be in DD-MM-YYYY Format only.
4) When Vehicle Number is entered only in Numeric Value then Update Vehicle code works fine,
But If Vehicle Number is entered in Numeric and Text Combined Value (MH09EM2727) then Update Vehicle code gives error.
5) I am unable to write code for Delete Button -
Expectations are as follow
If user will click on delete button then Delete Vehicle form will open
User will select the vehicle in combo box
and click on Delete Record button
It will ask "Do want to delete this vehicle permanently from database"
Yes No option
If user will click on Yes Button then message will come " Vehicle Deleted from the database "
If user will click on No Button then Dialog Box Screen will disappear and user will come on Delete form Screen.

Thanks in Advance
Atul

Kenneth Hobs
02-24-2019, 02:30 PM
Cross-posted: https://www.excelforum.com/excel-programming-vba-macros/1265830-vba-coding-related-to-data-entry-form.html