Excel - Excel 2003 + macro for validation

Hi i have a set up sheet which required cells i need the users to fill in, is
it possible that when the button is pressed it highlights all the empty cells
that needs filling in giving a message to the user to go back and fill in the
required fields?

Thanks.

  Mike H replied to Neil Holden

Hi,

Here I have sheet_Deactivate to call the code but there are several events you
could use. Note I have left the syntax in for 2 types of range

Private Sub Worksheet_Deactivate()
'For Each c In Range("A1:A10")
For Each c In Range("A1,C1,E1")
If IsEmpty(c) Then
MsgBox "You must fill in " & c.Address
Sheets("Sheet1").Activate 'Change to suit
Exit Sub
End If
Next

End Sub
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

Outils pour optimiser macro? Excel Bonjour: Je souhaiterais savoir s'il existe des outils et ou techniques pour diagnostiquer et / ou optimiser et / ou nettoyer le code d'une macro afin d'augmenter la rapidit = E9 de traitement ou les points de ralentissement. Remerciements et sinc = E8res. Christophe Excel - French Discussions WorksheetFunction (1) PageSetup (1) Worksheets (1) Scenarios (1) Interior (1) Borders (1) Sheets (1) Error (1) Bonjour Maud et merci. Est-ce que tu peux m'aider = E0 identifier les elements de la macro ci- dessous = E0 modifier pour acc = E9l = E9rer la vitesse de traitement? Beaucoup de ces lignes ont = E9t = E9 r = E9alis = E9es avec l'enregistreur de Macro ce qui = ne doit pas participer = E0 la fluidit = E9 de la macro. Remerciements et sinc = E8res salutations, Christophe Sub ShowtimeCompanyScheduler() If MsgBox(Prompt: = 3D"Are you really

Win7 VirtualStore Weirdness with Excel 2002 and earlier Excel I thought I'd share a weird experience I had today in case it saves installer for it - - which registers it as an add-in for all installed versions of Excel - - and tested it. Fine in Windows 2000 in all installed versions of Excel. Boot to Windows XP, fine there too. Boot to Windows 7. Fine in Excel 2010, 2007, and 2003. But Excel 2002 and 2000 were still loading the old version of the add-in. I uninstalled the add-in, made sure it was gone, and reinstalled it. Same problem in Excel 2002 and earlier; still works fine in Excel 2003 and later. I opened the VB

Pb de recalcul Excel Bonjour, J'ai un problème de recalcul de ma feuille excel. J'importe une colonne qui se retrouve en texte 0000 0000 0000 0000 FFF0 7FFF cela soit automatique ? Merci d'avance à ceux qui se pencheront sur mon cas. Caroual Excel - French Discussions WorksheetFunction (1) AddIns (1) Worksheets (1) Excel 2007 (1) Macro (1) Proc (1) LEFT (1) VBA (1) Bonsoir Dans la doc sur HEXBIN, ils ne 426a74cc@news.free.fr. . . Bonjour, J'ai un probl?me de recalcul de ma feuille excel. J'importe une colonne qui se retrouve en texte 0000 0000 0000 0000 FFF0 7FFF et un texte" Next ce que tu peux d = E9clencher = E0 l'aide d'une macro qui se charge de l'imp = ort = 20 avant, de fa = E7on que les deux micros. Je l'ai testée chez moi. Elle ne fonctionnait pas, j'ai coché la macro complémentaire Utilitaires d'analyses VBA. et elle a marché, à part le problème de recalcul

si oui cellule acceleration Excel Bonjour voici mon code sub flk Sheets("NON PAYEE TOTAL").Range("I3").Select Selection.Copy Range("J3").Select Selection.PasteSpecial Paste: = xlPasteValues, Operation: = xlNone, SkipBlanks _ Sheets("NON PAYEE TOTAL").Range("I3") = "" For I = Range("c65536").End(xlUp).Row To 7 Step I, 1).EntireRow.Clear ' le 2 correspond au numero de colonne Next ligne = 2 With Sheets("2007") For I = 1 To .[a65000].End(xlUp).Row If .Cells(I, "P") = "NON" Then .Cells(I, 1).Copy Sheets("NON PAYEE TOTAL").Cells(ligne + 5, 1) .Cells(I, 3).Copy Sheets("NON PAYEE TOTAL").Cells(ligne + 5, 2) .Cells(I, 13).Copy Sheets("NON PAYEE TOTAL").Cells(ligne + 5, 3) .Cells(I, 14).Copy Sheets("NON PAYEE TOTAL").Cells(ligne + 5, 4) .Cells(I, 15).Copy Sheets("NON PAYEE TOTAL

32 bit DLL with 64 bit Excel 2010 Excel We have an app which creates large Excel workbooks. For example, one workbook has 1, 000 worksheets. In other cases there are fewer worksheets but the Excel file can be 80 MB or larger. Since this sometimes crashes Excel 2007 and 2003, I am considering using 64 bit Excel 2010. Would 64-bit Excel be more reliable with workbooks this size than 32-bit Excel? Is 32-bit Excel