alt-enter in an inputBox

[Deepk]

Hi all,

I have a macro that combine data from a column into a cell. The macro ask to enter a separator in an inputBox and then combine all the data from a column range in a cell separated by the separator of interest.

Now I want to combine my data in selection with "alt-enter". I am not sure how to enter the "alt-enter" in the inputBox.

Help appreciated! Thank you.

 

[RoryA]

As far as I know, there isn't a way to type it in directly. You could perhaps specify an alternate character (or leave the inputbox blank) and have your code assume a linefeed character in that case.

 

[SpillerBD]

In the Text-to-Data wizard, you can use ALT+0010
Maybe? (But, I would be pessimistic even without RoryA's comment.)