Is a pop up, editable text box possible?

[rriiser]

Hi, I wonder if you may be able to help me -

I would like a pop up text box (similar to data > data validation > input message) to appear when you click on a cell, but then I want the user to be able to edit it by clicking on the box (rather than going into data validation again...)

So not like a comment as you have to right click to view/edit, I want it to be quicker...

I am very new to VBA, but don't mind having a go (the best I have got to so far is my own warning box!)

Hope you can help,

Many thanks.

 

[JamesW]

Hi,

Try playing about with an input box:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim iBox As String
    If Target.Count > 1 Then Exit Sub
    If Not Intersect(Target, Range("A1")) Is Nothing Then
        iBox = InputBox("Please enter something:", "InputBox o' Win")
        MsgBox iBox
    End If
End Sub

^^ When you select cell A1 it will show an input box, which you can enter things into.

Is this what you were referring to? Or was it more like a userform?

 

[GlennUK]

With a comment if you double-click the cell you go into Edit mode on the comment. Is that any help?

 

[rriiser]

Thanks James,
That is very useful! When the pop up box appears, and you fill something in (this is great) and press enter, how then do you keep the inforrmation that was entered so that you can see it next time you click on it - was hoping that when you click on A1 again, it would show what was entered in the box.

Many thanks!