Need help with Visual Basic Editor, I am confussed on this.

[susiesc]

I am to delcare a new variable new_obs and then set the variable to integer.
And below the comments at the top of the sub procedure, enter the following statements:
This variable will store the observation number of the quality control sample.

After I do that I have to set the value of the new_obs variable equil to one
plus the value of cell A3 in the QC Data worksheet.

I am given a hint: Use an object reference that includes the object hierarchy from sheets collection to the range object.

So this is what I have already done

This variable will store the observation number of the quality control sample.
Public Sub new_obs()
Dim num1 As Integer =1, QC Data A3


I am more confussed now then I was before, once I added them all came out red with errors.
Please help me understand how I am to write this please....


Susie

 

[VoG]

Try like this

Sub atest()
Dim new_obs As Integer
new_obs = Sheets("QC Data").Range("A3").Value + 1
MsgBox new_obs
End Sub

 

[T0rM3nT]

Sub FunctionName()

    'This variable will store the observation number of the quality control sample
    Dim new_obs As Integer

    new_obs = Sheets("QC Data").Range("A3").Value + 1
    MsgBox (new_obs)

End Sub

Try this. You can remove the MsgBox line if you want. It will just display the value of the new_obs variable.

EDIT: Woops, didn't realize someone had already responded with basically the same code.

 

[susiesc]

Yes that did it thanks for your help