1. E

    Can I store multiline text in macro and paste it as plain text?

    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!
  2. M

    Lookup Help

    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...
  3. E

    What does this mean in VBA?

    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!
  4. M

    Manualy insert multiline-text in Word Labels Template from VBA Excel

    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...
  5. T

    Split multiline text to two column retaining the multiline row structure

    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...
  6. H

    ActiveX text box bug: Multi-line property shrinks font when typing

    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...
  7. I

    Search string segments in multiline text and return rows on seperate sheet

    My problem goes like this, 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...
  8. J

    Retrieve Textbox Value

    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:
  9. B

    User Form - Show Multilines

    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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...