Guys, i need to automate a report creation for a nurse, i want her to click some option buttons on form ( it could be on word file) and after she finish she click submit, and she get the report in word file formatted well, what is the easiest method to do so, i tried the following:
Private Sub CommandButton1_Click()
Dim thyroid As String
If Normal.Value = True Then
thyroid = "Right and left thyroid lobes are normal in size."
Else
If enlarged.Value = True Then
thyroid = "Right and left thyroid lobes are enlarged."
End If
End If
End Sub
But i am not sure how to add the strings again in another file with accurate formatting,
is there any easier way you advise ? thanks.
Question
Guys, i need to automate a report creation for a nurse, i want her to click some option buttons on form ( it could be on word file) and after she finish she click submit, and she get the report in word file formatted well, what is the easiest method to do so, i tried the following:
Private Sub CommandButton1_Click() Dim thyroid As String If Normal.Value = True Then thyroid = "Right and left thyroid lobes are normal in size." Else If enlarged.Value = True Then thyroid = "Right and left thyroid lobes are enlarged." End If End If End Sub
But i am not sure how to add the strings again in another file with accurate formatting,
is there any easier way you advise ? thanks.
Link to post
Share on other sites
0 answers to this question
Recommended Posts