Hello all,
I have a userform with Listbox1 which shows values from column range (DX20:DY170).
The listbox has two columns.
Column 1 is document number (see below)
Column 2 is description (see below)
So what I am looking to do is to select one or more rows in the list box and click on commandbutton1 which will run vba code to copy the values in column 1 only to clipboard.
Then I can manually paste the copied data into another worksheet or word document.
I got code from another post but as it isn't related to my userform listbox, It didn't work as expected as when I clicked on command button with the code and then pasted the copied data into a word document it pasted the values as , so not actual text.
Could anyone please help me with this?
let me know what you need to help me with this code.
Userform1
Listbox1
thank you.
I have a userform with Listbox1 which shows values from column range (DX20:DY170).
The listbox has two columns.
Column 1 is document number (see below)
Column 2 is description (see below)
So what I am looking to do is to select one or more rows in the list box and click on commandbutton1 which will run vba code to copy the values in column 1 only to clipboard.
Then I can manually paste the copied data into another worksheet or word document.
I got code from another post but as it isn't related to my userform listbox, It didn't work as expected as when I clicked on command button with the code and then pasted the copied data into a word document it pasted the values as , so not actual text.
Could anyone please help me with this?
let me know what you need to help me with this code.
Userform1
Listbox1
thank you.