On Feb 1, 6:34*am, "Nigel" wrote:
Try moving the code to the UserForm initialize event.....

--

Regards,
Nigel


"Chet" wrote in message

...



I am trying to feed or supply a userform text box a variable which I
have assigned in my main code module. *I am having a problem getting
the variable data to display in the userform when I show the user
form. *A blank userform text box shows up instead. *I'm doing
something wrong. *Here is what I did.

1. Created the variable FormTextToShow in my main code module and
named it as a Public variable.

FormTextToShow = "Program will run for location " & Location & " for
month of " & MonthAlpha & " " & TargetYear

2. I have the following code in my "form module". *Textbox3 is the
variable that should be feeding the textbox.

Private Sub CommandButton1_Click()
* *TextBox3.Value = FormTextToShow
* *TextString1 = TextBox3.Text
* *PrelimStatus = OptionButton1.Value
* *FinalStatus = OptionButton2.Value
* *MinMinutesToKeep = TextBox2.Text
* *FilterOut = CheckBox1.Value
* *SaveToDesktop2 = OptionButton3.Value
* *SaveToMyDocs2 = OptionButton7.Value
* *SaveToFltSched = OptionButton8.Value
* *SaveToGeneral = OptionButton4.Value
* *SaveNo = OptionButton6.Value
* *Unload FltSchedAnalysis
End Sub

Possibly i am doing it in the wrong sequence or section of code.
Where should I put the code you mentioned?

The problem is when I run the main code and the variable
FormTextToShow does not show up. *I just get a blank
textbox showing up on my form. *(I did do a step-through it test and
ran the code and the FormTextToShow variable did show up then in my
textbox3.) * My idea is to show the user what data the program will be
running in the userform so I'm actually "feeding" the user form.

What am I doing wrong? * Thx *much... Chet- Hide quoted text -

- Show quoted text -

That did the trick!.. Thank you .. . Chet