adamsm
05-11-2011, 11:06 AM
Hi anyone,
Im trying to make the following code to insert the form text box values and combo box values to the cell referenced in the code.
Private Sub cmdAdd_Click()
Dim strSentence As String
strSentence = Me.TextBox001 & " " & Me.cbofrequency1 & " " & Me.Label001.Caption & " " & Me.cbodos1
Worksheets("Crd").Range("I55") = strSentence
End Sub
But the code only inserts the textbox001 value and the label value. It does not enter the rest of the values.
What have I done wrong in here.
Any help would be kindly appreciated.
Im trying to make the following code to insert the form text box values and combo box values to the cell referenced in the code.
Private Sub cmdAdd_Click()
Dim strSentence As String
strSentence = Me.TextBox001 & " " & Me.cbofrequency1 & " " & Me.Label001.Caption & " " & Me.cbodos1
Worksheets("Crd").Range("I55") = strSentence
End Sub
But the code only inserts the textbox001 value and the label value. It does not enter the rest of the values.
What have I done wrong in here.
Any help would be kindly appreciated.