required fields

Hi, I have a data entry form with a save button - I am wanting to check that the text box has a value before submitting to table. Private Sub btn_save_Click() Dim strSQL As String Dim DB As DAO.Database Dim RS As DAO.Recordset Dim ctl As Control...

I have the following code in a button and would like to add the code to check for required fields on the spreadsheet before it sends the email and to not send unless all the required fields are required, but not sure where to put it in this code - Thank you!: Sub Email2() ' Keyboard Shortcut...

Hello. I have a userform that I use to introduce some data on Excel. Most of the data must be filled (that are textbox that the verifications dont need the information to do the calculations), because if they are not filled the rest of the Worksheet cant do the verifications that I need...

(Excel 2007) I have a workbook with several sheets with cells that require user input. Some fields are not that important, but others are very critical. All the critical fields say 'Required', but I still get people returning the workbook with no entry in these fields. I need a before-save macro...

Re: Email Code needs a LITTLE Tweaking. Help PLEASE. I'm using more or less the same email button code as Mister H in his thread, borrowed and slightly modified to suit my needs. What I'm trying to do now is get the same button-click to ensure all "required fields" are filled in prior to...

Hello: I am using a userform which requires a user to enter data into a sheet, but if they skip a field they get a message requiring the data. Yet, when I run the code, it works, but if I click a button, it gives the message as well. See my code below. I am messing up somewhere. I want it...