VBA inputbox user new line

[BlueBeerR]

Hi,
I have a VBA code that gets input from the user.
I want that click on ENTER will get a new line.

 

[dmt32]

Hi,
I have a VBA code that gets input from the user.
I want that click on ENTER will get a new line.

Hi,
welcome to forum
It would be helpful if you can Publish your code - plenty on forum to offer assistance.

Dave

 

[BlueBeerR]

Hi,
Here is the code

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim str As String
Dim newTXT As String
str = Target.Value
newTXT = InputBox(str, ActiveCell.offSet(0, -1).Value, str)
Target.Value = newTXT
Range("A1").Select
End Sub

 

[Jon Peltier]

Yeah, an InputBox won't work that way. You either have to build a UserForm with a textbox that accepts a line break, or you can use some kind of indication where the line break should go. For example, insert a line break where the user types <newline>.

 

[footoo]

I'm not sure what you want to do.
Do you mean like this? :

Target.Value = newTXT & vbCrLf