Mandatory Cell Input

**red1234** · 07-11-2016, 03:54 PM

Hi,

I have an Excel file with Column Headers in it. This Excel file will be fill in with few rows of data by another party.
Several columns are required. But not all are required.

I know how to make a VBA for mandatory cell input but only for specific cells. The idea is that I don't know in advance how many rows the the other party will make. Basically when the user starts filling the first row only then specific cells from that row are required in case that the cells are left blank( by a message box or something similar-without the user to have the possibility of saving or closing the document without filling the cells required)
As I mention I have no information about how many rows the user will fill therefore somehow it has to be dynamic.

If someone can help with some ideas that will be very much appreciated.
Thanks in advance

**AlphaFrog** · 07-11-2016, 04:52 PM

When the user tries to save the workbook, this tests for each used cell in column A on Sheet1 if there are values in columns CDE and G.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    With Sheets("Sheet1")
        For Each Cell In .Range("A2", .Range("A" & Rows.Count).End(xlUp))
            If Application.CountA(.Rows(Cell.Row).Range("A1,C1:E1,G1")) < 5 Then
                Application.Goto Cell.EntireRow
                MsgBox "Missing entries in required columns A-C-D-E-G" & vbLf & _
                        "Please review and fill in the required columns", vbExclamation, _
                        "Save Workbook Canceled"
                Cancel = True
                Exit For
            End If
        Next Cell
    End With
End Sub

EDIT: Paste the code in the ThisWorkbook code module.

**red1234** · 07-13-2016, 11:16 AM

Thank you

Mandatory Cell Input

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Mandatory Cell Input

Re: Mandatory Cell Input

Thread Information

Users Browsing this Thread

Similar Threads

Make multiple cell input mandatory if initial cell has input.

[SOLVED] Mandatory Input based on another cell

Save file using cell references & mandatory cell input

make input mandatory for specific cell in a row if any cell in the same row contains data

how to generate error message for an empty cell (mandatory input cell)

Mandatory cell input with drop down menue

To make several cells mandatory based on other cell input.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions