I need help with writing a code in Visual Basic

[susiesc]

Use the add new data macro button to add sample values to the quality control chart:
65,67,64,66, and 68. Verify that the new data is added to the control chart and to the QC Data worksheet.
Also verify that the sample values 67 and 68 are reported by the macro as being out of control.

So I have already assigned the New Data Button, but am so confussed on how to add what is above.

Please help

ActiveCell.FormulaR1C1 = "new_data variable"
Range("C4:E4").Select
Selection.Copy
Range("C3:E3").Select
ActiveSheet.Paste
Range("E4").Select
Sheets("QC Chart").Select

 

[VoG]

You are not helping yourself by asking the forum to do your homework. The macro recorder will help plus see http://www.tushar-mehta.com/excel/vba/beyond_the_macro_recorder/

 

[susiesc]

I just needed a suggestion; I will check out the website. Thanks