RefEdit modify user input string

[hiici]

Hi VBA Gurus,

I am trying to take the cell a user clicks and allow them to add to the input box string. I have figured out how to strip the tab name and just show the Cell after selection but when I try to modify the input box, it simply overwrites it.

For example say I want the RefEdit box to contain the string A1+B1+C1.

When I select A1, that is what shows in the box, then I add a plus sign and highlight B1 and the result is simply overwritten with B1.

I've tried a bunch of the RefEdit controls and still can't figure out which one I need to use to accomplish this. This is probably very simple but I still cant find where I would control this.

thx for any help.

mike

 

[Marcelo Branco]

See if this does what you need

Sub aTest()
    Dim myString As String
    myString = Application.InputBox("Select Cells", Type:=0)
    myString = Mid(Application.ConvertFormula(myString, xlR1C1, xlA1), 2)
    MsgBox myString
End Sub

When the Input Box opens
Select A1
type +
Select B1
type +
Select C1
OK

M.

 

[hiici]

that works perfect thanks Marcelo. I guess it is those RefEdits that make life difficult because this was too with your method

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.