multiline

Hi! Can I store a multiline text which contains formulas and text and use a macro that will activate the A1 cell and then paste the multiline text? Thanks!

Hi, I have a spreadsheet with 2 tabs. 1 tab contains multiline values (column A) and it's master name (column B) The other tab has split out those multiline values into separate rows What I now want to do is look up the master name in the split out sheet but I can't figure out a way to...

Hello I generated a macro through the recorder and it generated the following code: ActiveCell.FormulaR1C1 = _ "§ 4,795.............. What does the =_ mean? Also, is it possible to use multiline text/code for the ActiveCell.FormulaR1C1 ? Thanks!

Hello :) The idea : 1 Select data : The Macro open a FilePicker to select the file.xls where the data (adresses) are. Then you choose the sheet and manualy put the columne into B4. 2 Launch : Get the data from the file/sheet/column specified in B2-B4. Then generate a Word document from Label...

Hi, My data looks like this (two rows, one column) apple [fruit] orange [color] grapes [sour] banana [yellow] mango [sweet] I want to convert them into (two rows, two column) as below apple --------- fruit orange ------- color grapes ------- sour banana ------- yellow mango -------- sweet...

I have Office 2013, and have an Excel inspection form our technicians are going to be filling out in the field on tablets. There is a section for Notes that they can enter free text, and I've used an ActiveX text box for that purpose. But if I set the property "Multiline" to true, the font...

My problem goes like this, http://img121.imageshack.us/i/67286679.png/ The sheet above is a section of a maintenance schedule for a machinery. tasks based on the schedule are assigned to the mechanics as cards (based on card Reference Column C). the first set of characters before the hyphen...

I have a textbox which is a multiline textbox and has 10 lines of text. My question is, how do I retrieve only the value from line 10 into another textbox, i.e. retrieve the 10th line value of textbox1 into textbox2. Thanks.:confused::confused::confused:

I have a userform. I'm getting some info and write all this infos to column A down by down... and there is another text box which is reading all infos in column A. But I don't know how to show all info down by down as inserted in column A. I already changed textbox MultiLine as True. Please...