T
TomP
I have a value collected from a code and have cell assignment.
Dim SMPL as String
Range "A1" = String
I started to create a form and textbox along with the common OK and cancel
button, but is there a simple way to pass a string value to a form?
When I ran the code and initialized the form the text box would show
Me.Change1.Value=(SMPL).
*** From a Form ***
Private Sub Change1Text_Change()
Me.Change1.Value = (SMPL)
End Sub
My intention is to create a checkbox next to the texbox. If the checkbox =
true then the string will be placed in the cell. If the checkbox = false,
then the string will be null and not printed.
The reason I am asking this because at times, the "user" will need to have
the option to select all or portions of the data collected.
Thank you,
Tom
Dim SMPL as String
Range "A1" = String
I started to create a form and textbox along with the common OK and cancel
button, but is there a simple way to pass a string value to a form?
When I ran the code and initialized the form the text box would show
Me.Change1.Value=(SMPL).
*** From a Form ***
Private Sub Change1Text_Change()
Me.Change1.Value = (SMPL)
End Sub
My intention is to create a checkbox next to the texbox. If the checkbox =
true then the string will be placed in the cell. If the checkbox = false,
then the string will be null and not printed.
The reason I am asking this because at times, the "user" will need to have
the option to select all or portions of the data collected.
Thank you,
Tom