locked
An input box for accepting two lines RRS feed

  • Question

  •  Hi

    I've copied two lines at the same time on the clipboard

    Is there a macro for input box that
     could be the first line in the cell  A1  & second line in the cell  A2
      Paste.

    thanks

    Thursday, February 8, 2018 12:57 AM

Answers

  • Hi kapriano,

    I'm afraid it would be impossible. Please make a UserForm and place a TextBox (MultiLine=True) in it.

    I guess you want to show InputBox many times and don't want to make many UserForm(s). If this is correct, please make a universal (commonly used) UserForm, and change caption of the UserForm,  caption of a Label (it's a Title in InputBox) according to your case.
    Regards,

    Ashidacchi

    • Marked as answer by kapriano Thursday, February 8, 2018 8:45 AM
    Thursday, February 8, 2018 5:09 AM

All replies

  •  Hi

    I've copied two lines at the same time on the clipboard

    Is there a macro for input box that
     could be the first line in the cell  A1  & second line in the cell  A2
      Paste.

    thanks

    Thursday, February 8, 2018 12:57 AM
  • Hi kapriano,

    I'm afraid it would be impossible. Please make a UserForm and place a TextBox (MultiLine=True) in it.

    I guess you want to show InputBox many times and don't want to make many UserForm(s). If this is correct, please make a universal (commonly used) UserForm, and change caption of the UserForm,  caption of a Label (it's a Title in InputBox) according to your case.
    Regards,

    Ashidacchi

    • Marked as answer by kapriano Thursday, February 8, 2018 8:45 AM
    Thursday, February 8, 2018 5:09 AM
  • Hi  Ashidacchi . ok .ok !!! . Regards,
    Thursday, February 8, 2018 8:47 AM