Excel userform vba question

Discussion in 'OT Technology' started by BROKE, Oct 16, 2009.

  1. BROKE

    BROKE Mr. Selfdestruct

    Joined:
    Nov 17, 2004
    Messages:
    48,344
    Likes Received:
    0
    Location:
    Austin,Tx
    I have an excel user form that looks like this


    label 1
    textbox1


    label2
    textbox2


    label3
    textbox3

    Im tryin to create a copy button to copy the data from the form so it looks like this when i paste it.

    label1:
    text from textbox1
    ==================================
    label2:
    text from textbox2
    ==================================
    label3:
    text from textbox3
    ==================================

    when i paste it. with each section seperated by =================.
    I can get the button to copy one text box but thats about it. Any ideas?
     
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    That's a clusterfuck of a question - I might help if you posted a before and after .xls doc of what you want it to look like.
     

Share This Page