title: Losing ActiveCell.Value when closing TextBox from which value copied
body: <p>So I'm using VBA UserForm in Excel to capture values. Problem is that after assigning value to ActiveCell and after value initially appearing in cell, The value disappears when I Close TextBox. I Think I Understand why this happens, just Don't know how to preserve value after closing TextBox. Thanks in Advance.
                                                 Paul L</p>