+ Reply to Thread
Results 1 to 2 of 2

Just background

  1. #1
    Registered User
    Join Date
    03-31-2021
    Location
    Thailand
    MS-Off Ver
    Office Professional Plus 2019
    Posts
    0

    Just background

    Hi Forum
    I’m retired coming from Automation with PLC: s getting some idea’s but not knowing “how to” I came here.
    When I worked 13 years ago, we used Excel collecting data from the PLC and showing diagrams like motorspeed, temperature a.s.o, quite simple things.

    I still “play with “and sometimes support old PLC: s mostly to have something to do.
    Now I use an LED matrix 8 * X writing sentences on the matrix using Excel to design letters and calculating hex values to set the pattern for LED: s.
    It works fine but lot of cut/past.

    Then I just copy the top row to an array in PLC the and it writes "TUV".

    I’m thinking about somehow write “Hello World” and Excel can find the pattern for each letter and generate just the top row somewhere in Excel.
    Looking in the forum I see that members are far above my knowledge but I’ll be back with Q:s anyhow 😊 but first I’ll see if I can find an idea ”How to”.
    Attached Images Attached Images

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello BjornF,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. [SOLVED] format a cell background colour based on a manual background colour of an adjacent cell
    By Nampara in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-24-2018, 04:03 PM
  2. Replies: 8
    Last Post: 04-02-2016, 04:00 AM
  3. Replies: 2
    Last Post: 01-05-2016, 06:36 PM
  4. Change cell background color based on another cells background color
    By Queo in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 06-10-2014, 05:28 AM
  5. Replies: 6
    Last Post: 11-07-2012, 10:46 AM
  6. [SOLVED] Macro to change all cells with a certain background color in another background color
    By kevinvzandvoort in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2012, 11:04 AM
  7. Button Background Picture to Fill Button Background
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-22-2011, 09:32 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