Userform textbox used as refedit

Hi guys,

I hope what I am trying to achieve is possible, if not please suggest another way.

I have a userform that is called from a button in excel. The userform has a couple of text boxes in which the user can either fill values, refer to any cell on the sheet (might never be the same one twice), and type excel or custom formulae, or a combination of these.

I tried using the refedit, but for some reason I cannot type a formula, and then select a cell, as you would find in the "Insert function" block, in fact, the "Insert Function" tab is what I would like to replicate:

label: textbox = value
label: textbox = value
label: textbox = value
-----------------------------------------
= value

The only diference is that I would like to be able to store each text box individually on a hidden sheet.

If what I have asked is unclear, please ask and I'll try to clarify more.

Thanks in advance.