P.S. SMPL would have to be a public variable to be used between modules.

"TomP" wrote:

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