How could I retrieve the variable that was entered in the user formand then used in other place out of the userform subroutine ?I have tried to defined the combo box as public or the textbox aspublic, but it doesn't work.
There are a number of places/ways. You seem familiar with global stuff soyou can declare a global variable and set that to the value in thecombo/text/list box. You can get the value of that control if you haven'tunloaded the userform by referencing it explicitly...userformname.controlname.value. You can save the value in a .TAG property ofthat or any other control and then reference that explicitly.Just some options.
You can try with UserForm1.<VariableName> or with UserForm1.<TextBoxname>This will solve your problem