mandatory cells

I have to make a few hundred forms to various e-mail addresses, but I would like to prevent empty answers. I used "Data Validation" option (unchecked "ignore blank"), but you must enter the cell to activate this, if you don't enter you will not trigger validation. I tried to find the VBA code...

Hi there, I Wondered if this was even possible and i'm newish to VBA: Notes: Column J is a data validation list and the below is from A:W ISBNCustomerDivisionTitleAuthorPub dateRRPFormatImportant Do Not TouchPromotionAdditional infoImportant Do Not TouchChart DateMod BreakStorebaseDiscount...

Hi I am new to excel and having a mess around with creating mandatory cells. My worksheet is basically 15 columns across (A-0) and due to me having hidden layers above, for some rows to be auto filled, the first row where the data entry will begin is on number 27. I have managed to create a...

I'm very new to Excel formulas and really struggling. I'm creating a spreadsheet which lists items and their specifications. Eg. column A has the item name, B has the size, C has the file type, D is the due date etc. I want to make sure that if people add an item that they fill out ALL the specs...

I am looking to do the following: When user opens the excel file, a pop up tells them they have to fill out cells A1, A2, A3 (as an example) in order to move on to any other work in the file. Then, the user is forced to complete cells A1, A2, and A3. Once fields are complete, all other cells are...

Hello Excel experts, I have been running around to find a solution for making several cells in different sheets mandatory to fill. The excel will be sent to third party to fill and send back, I would like to avoid email ping pong to ask for missing cells, below is the code I am using and it...

Hello, I would like to mandate a comment in column D, if user selects a value of 1 (out of a drop down list of 1,2,3) in column C. For example, if the user selects 1 in column C5, then the user must not be able to move to next without filling in a comment in D5. Please help. Thanks

Hi I am new here and to VBA and am looking to make some cells in my spreadsheet mandatory if another cell is completed, If column B is complete then there must be something in C,E,F and this would be for rows 1:17 Thanks in advance Sharon

Hi All - I am trying to make cells in a column mandatory based on the input of a different column. If the user enters any input at all in column I, then the user must choose from the dropdown menu in column K before saving. However, if there is no input in column I, then nothing would be...

Hi everyone, I just stumbled upon a topic which seems to not have been discussed yet, although it is very ineteresting to me. Situation is: I have a file (an order form I created as an Excel sheet) for which I threw together a rather beginner level of VBA code. Task was to make four...

hi, i have a requirement where i have to format the row based on the input in Column A also i have to lock few cells of that Row based on the input. for Example say the Data entered in column 'A' is 'MAIN', then i need to change the color of that row and also lock Cells of C,D and E for that...

Hello, I have typical sheet to update all mandatory fields ...the moment if I enter the A2 then entire row 2 till J2 cells should become mandatory fields. If anyone fails to update the data in the given cell then that sheet should not save the file and also should stop the excel access. Thx

Hi there, I'm new in the forum. Hope some kind soul helps :) I wrote this code without many idea of VBA thanks to the search tool: Private Sub Workbook_BeforeSave(ByVal SaveAsUi As Boolean, Cancel As Boolean) Dim msg As String With Sheets("Form") If WorksheetFunction.CountIf(.Range("C5")...

Hello all, I'm sorry if this has been asked before but I've only found part answers! I'm a newbie and have never used VBA before and have basically figured out what I have got so far using various answers found on the net and trial and error! Basically I have a sheet that is an expenses...