WORKSHEET USERFORM INPUT VALIDATION

DawidV

New Member
Joined
Jul 14, 2016
Messages
29
I am busy building an InputForm on a worksheet in order to get control over the integrity of the data in the dataset. I have put in some Input validation in all the cells to control that the cells will not be empty when you save the data to the worksheet. I have included a copy of my project and the validation is in Column I. I have uploaded the mini sheet.

My request for help with the validation is the following starting from the first cell H6:

When you complete the entry in Full Tender Description [Cell H6] TRIM data in Cell and update Add Record (Timestamp) [Cell H32] with the date & time in the =Now()FORMAT(dd MMM yyyy HH:mm)

When you complete entry in Tender No [H7] TRIM data in cell and update Add Record (Timestamp) [Cell H32] with the date & time in the =Now()FORMAT(dd MMM yyyy HH:mm)

Envisaged award date [H20] – default date must be =Now() FORMAT(dd MMM yyyy). Must be automatically be calculated from Tender closing Date [H13] + Offer valid for – DAYS[H19]. Must be calculated as soon as Tender closing Date [H13] has been entered/updated

Compulsory Briefing [Cell H14] – Has a dropdown with Yes/No. Default is NO. If Selection is NO then the value in Briefing Date/Time [H15] must be set to “No Formal Briefing”.

If Compulsory Briefing [Cell H14] – Has a dropdown with Yes/No. If Selection is YES then the value in Briefing Date/Time [H15] must be able to take a DATE in FORMAT (dd MMM yyyy HH:mm).

Copy of Tenders Database Workbook_08-Sep-21.xlsm
K
137
InputForm
 

Attachments

  • InputForm.jpg
    InputForm.jpg
    167.5 KB · Views: 11

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Forum statistics

Threads
1,144,281
Messages
5,723,471
Members
422,499
Latest member
think say

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top