I have a userform using RefEdit input fields. When selecting a desired cell in excel, the input shows up in the following format; Sheet1!$M$15. What can I do for the input to avoid inserting the current sheet title in the box and also not have the cell locked in? I want the box to show simply say M15.
Bookmarks