+ Reply to Thread
Results 1 to 7 of 7

text creation

  1. #1
    Registered User
    Join Date
    03-24-2017
    Location
    Riga
    MS-Off Ver
    2016
    Posts
    25

    text creation

    Hello.

    Need some help with this one:

    In excel file are marked 7 cells. Is it possible to create text like below and for each text add that specific cell? (For example text should be in cell E2)

    Försäkringsbolag: C2
    Försäkringsnummer: I14
    Startdatum: V14
    Självrisk: J14
    Nypris: D14
    Customer care: C5
    Artikel-nr: B14

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: text creation

    Can you put some expected output? It is not totally clear
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Registered User
    Join Date
    03-24-2017
    Location
    Riga
    MS-Off Ver
    2016
    Posts
    25

    Re: text creation

    Please see picture.

    Capture.JPG

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: text creation

    Hello try this code (replace H1,H2 and so on with your headers
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-24-2017
    Location
    Riga
    MS-Off Ver
    2016
    Posts
    25

    Re: text creation

    Good morning.

    Not sure, why everything works fine, excep last line "H7"

    a = Array("Försäkringsbolag: ", "Försäkringsnummer: ", "Startdatum: ", "Självrisk: ", "Nypris: ", "Customer care: ", "Artikel-nr: ", "Artikel-nr: ")
    b = Array("C2", "I14", "V14", "J14", "D14", "C5", "B14", "B15")

    Tried to add one more line and just then it works. Could you please help me to understand why?

  6. #6
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    532

    Re: text creation

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    03-24-2017
    Location
    Riga
    MS-Off Ver
    2016
    Posts
    25

    Re: text creation

    Thank you a lot

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dynamically creation of text boxes through a buttonClick
    By cvelle89 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-15-2015, 05:16 AM
  2. Formula Creation Display Text (SOLVED)
    By jumpingjack139 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 05-17-2015, 10:14 PM
  3. Spliting text and new rows creation.
    By pomper in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2015, 10:35 AM
  4. [SOLVED] problem obtaining correct Text-to-be-displayed in hyperlink creation
    By dschmitt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2014, 10:55 PM
  5. Excel file creation dates do not match the windows creation date.
    By alexthapyro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2011, 12:14 PM
  6. ASCII text file creation problem
    By annep in forum Excel General
    Replies: 2
    Last Post: 09-25-2006, 09:08 PM
  7. [SOLVED] Would Like to Automate Batch File Creation and Text FIle Import
    By socrtwo in forum Excel General
    Replies: 2
    Last Post: 08-18-2006, 11:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1