I have a the value Sheet9.tbSig.text stored in Cells(2,7)
I have am using
Public LoggedInUser as String
to store the value in Cells(2,7)
I have the following call to open an Outlook e-mail and fill in all fields.
Public Sub Mail_Export(ByRef mTO As String, ByRef mCC As String, mSubject As String, mBody As String)
I am using the following all to fill this:
Call OutlookEmail.Mail_Export(cboAssignedTo.Value, Sheet9.tbEPRUpdateCC, "(FOUO) " & cboMember.Text & " EPR Update(FOUO)", Sheet9.tbFOUO.Text & vbCrLf & vbCrLf & Sheet9.tbEPRUpdateBody.Text & vbCrLf & vbCrLf & _
LoggedInUser & vbCrLf & vbCrLf & Sheet9.tbFOUO.Text)
When I use the above call for the variable LoggedInUser it uses "sheet9.tbsig1" and not the value of sheet9.tbsig1.
however when I type in the immediate window LoggedInUser = sheet9.tbsig1 the text of tbsig1 is filled into the call procedure. Any help on how to fix this so the value of the textbox is filled into the call procedure??