In Excel's userform, there is a special control called "RefEdit", it is similar to a textbox but is used to retrieve cell address(es).

My question is: When you select a cell or drag a selection, the RefEdit control always replaces whatever text string you have in it with the cell address(es) of your selection. Is there a way to make it append instead of replace?

For instance, when I run the userform, I type "A1+A2+" in the RefEdit control, then with the mouse I click on cell A3. I was hoping that the text in that RefEdit would change to "A1+A2+A3", but instead I got only "sheet_name!A3". It replaced whatever I typed previously with the cell address I just clicked. How do I append instead of replace?