prompt user to fill out particular cell

**djspot** · 08-09-2007, 02:59 PM

I dont even really know how to word this but I'll give it a go!

What Im looking for, if possible, is to get what you get with a lot of online forms, where they require you to fillout certain fields.

I need my agents to have no choice but to fill out their names and date on their sales sheets. Can I have them not be be able to save a sheet until they have entered this info. And maybe have a dialog/warning box letting them know that they haven't done this when they try to save their spreadsheet.

**mudraker** · 08-09-2007, 05:57 PM

You will need to use a macro

The problem is that it will not work if macro security setting is high

The code works on a sheet called Sheet1 & looks at A1 & A2

'These instructions pre typed & are worded to cater for the novice programmer

'To install macro to correct location

'Copy this macro
'GoTo Excel
'Open VB Editor by pressing Alt + F11
'Just below the menus & toolbars on the left you should see Project - VbaProject window
'In this window you will see ThisWorkbook
'double click on ThisWorkbook - opens ThisWorkbook module sheet
'Paste macro code into big window on right

Private Sub Workbook_BeforeClose(Cancel As Boolean)
   With Sheets("sheet1")
      If .Range("a1").Value = "" Or .Range("a2").Value = "" Then
         Cancel = True
         MsgBox "Please Fill In Name & Date", vbInformation
      End If
   End With
End Sub