Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    suggestion....very important. (2000 sr-1)

    Attached is my one of userform.
    Each button M3, NX, 9H ecc... are created to the hand and assign to the the same code.
    When i have created first interface i have used 10 button.... (all buton is the name of var imported from a txt file)
    but now after 10 days of work in txt file are present new var for example named R45, 54E...ecc
    Not os possible for me to add a new button and recopy in the event the code standard. Is IMPOSSIBLE!!!! This method destroyed my head, sure!!!!
    Suggest me other way or other startegy or a new interface....
    In effect i want to add a new button dinamicly each time when from import of text is present a new var.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: suggestion....very important. (2000 sr-1)

    Instead of all those buttons and text boxes you could use a list box that shows the values M3, MK, AN etc., and two text boxes: one for NR and one for ULTIMO INVIO.
    When the user selects an item in the list box, fill the text boxes with the corresponding data.
    This way, it doesn't matter how many values there are.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: suggestion....very important. (2000 sr-1)

    NICE!!!!
    I mofify just today.
    Tks.
    In this case a can use the same code, assigned actually for each button, in a GLOBAL or use a Function and chamge the value of var based the items in listbox... wath you think about?
    In this case i canot repeat and recopy in each event for all button, or not?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: suggestion....very important. (2000 sr-1)

    You only need one button, next to the 2 text boxes. You can get the value of var from the list box, and use that in the code.

  5. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: suggestion....very important. (2000 sr-1)

    aaaaahhhhhh..
    Tks Wizard.

Posting Permissions

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