Hello Bob
I have two drop down boxes in a workbook that the user selects product and
language (from another workbook called Dbase). The drop downs were drawn on
the worksheet using forms toolbar. Under the drop downs I have normal cells
that the macro copies into another sheet for the generation of a manifest,
the macro then clears the cells by turning the cell link back to 1 (blank).
The quantity box is just number format for the actual number of sachets
being dispatched, the macro has been copied from another author and adapted
to my needs as follows;

Sub ADD_PRODUCT()
'
' ADD PRODUCT TO CHECK WEIGH SHEET Macro
' Macro recorded 21/03/2004 by sara
' HIDE UPDATE FROM USER
Application.ScreenUpdating = False
Sheets("DATA").Select
Range("A1").Select
Selection.CurrentRegion.Select
' check for empty table
If Range("a2") < "" Then
Selection.End(xlDown).Select
End If
ActiveCell.Offset(1, 0).Range("A1").Select
Sheets("INPUT").Select
Range("SACHETS").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Paste
ActiveCell.Offset(0, 1).Range("a1").Select
Sheets("INPUT").Select
Range("CODE").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("DATA").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=
_
False, Transpose:=False
ActiveCell.Offset(1, 0).Range("a1").Select
Sheets("input").Select
Range("b1").Select
Selection.ClearContents
Range("B1").Select
ActiveCell.FormulaR1C1 = "1"
Sheets("input").Select
Range("d12").Select
Selection.ClearContents
End Sub

So to recap, I would like a user form or pop-up to ask the user if they are
sure the information they want copied is correct and/or if any of the three
requirements are not met, the button (form control) associated with the
macro would be inactive. Does this make sense?

Sara