MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

UserForm Question

  Asked By: Thomas    Date: Oct 14    Category: MS Office    Views: 1460

How could I retrieve the variable that was entered in the user form
and then used in other place out of the userform subroutine ?

I have tried to defined the combo box as public or the textbox as
public, but it doesn't work.



2 Answers Found

Answer #1    Answered By: Friso Bakker     Answered On: Oct 14

There are a number of places/ways. You seem familiar with global stuff so
you can declare a global variable  and set that to the value in the
combo/text/list box. You can get the value of that control if you haven't
unloaded the userform  by referencing it explicitly...
userformname.controlname.value. You can save the value in a .TAG property of
that or any other control and then reference that explicitly.

Just some options.

Answer #2    Answered By: Ula Hashmi     Answered On: Oct 14

You can try with UserForm1.<VariableName> or with UserForm1.<TextBoxname>
This will solve your problem

Didn't find what you were looking for? Find more on UserForm Question Or get search suggestion and latest updates.