Help with Visual Basic Editor

[zainahli]

I am trying to declare the new_data variable by storing the actual quality control values. I have to set the data type of the variable to Single and set the value of the new_data variable equal to the numeric value returned from an input box. The input box prompt should read Enter tensile strength value and the input box title should be Add Data. I'm so confused!
This is what I have so far :
Public Sub new_data()
Dim new_data As Single
new_data = Sheets("QC values")
End Sub

 

[patel45]

1) you can not use the same name for sub and variable
2) you can not declare Single a variable for a sheet
if you are in doubt avoid declaring

[FONT=courier new]Public Sub new_data()[/FONT]
dim [FONT=courier new]new_sheet as Worksheet[/FONT]
[FONT=courier new]new_sheet = Sheets("QC values")[/FONT]
[FONT=courier new]End Sub[/FONT]