Hi All,
I would like to know if it's possible:
I have a Listbox that is populated by a spreadsheet via a OptionButtons. IE:
There are 8 option buttons and each populates the listbox with data ranging from two rows up to 10 rows.
Please Login or Register to view this content.
The List style is fmListStyleOption
I would like that when the user selects the box that the contents of that box be copied to the clipboard so it can be pasted into another application.
Best Regards
John
Last edited by JJFletcher; 10-23-2015 at 07:11 PM.
Hello JJFletcher,
Difficult, for me at least, to provide you with a ready answer, without a sample Workbook.
But you could try to add the below to your code:
Regards.Please Login or Register to view this content.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Please Login or Register to view this content.
When added to the code - indicates
Runtime error '2147024809 80070057)
DataObject:SetText Invalid argument
this was for this code offered:
Please Login or Register to view this content.
Last edited by JJFletcher; 10-17-2015 at 03:25 PM.
Kenneth..
your solution provides data - it actually copies the entire Column of data...
When the user selects a row and the box has a check in it - Only that row of data should be copied - Almost there
Best Regards,
John
Last edited by JJFletcher; 10-17-2015 at 03:23 PM. Reason: grammer
John
How do you want the selected items/rows in the listbox to be put on the clipboard?
As some sort of delimited list?
If posting code please use code tags, see here.
Private Sub OptionButton1_Click()
Me.ListBox1.RowSource = "B12:B20"
Range(ListBox1.RowSource).Copy
End Sub
This does copy , but the entire 8 rows
The DataObject requires the MSForms reference to be added in the Tools menu.
Please Login or Register to view this content.
Hi Norie,
Just the row that the user has selected from the ListBox - when the user selects the row they want the box is checked
image2.jpg
Kenneth - You are so close... I added the 8...
It is only copying the first row of the eight in this setPlease Login or Register to view this content.
I thought you were selecting multiple items?
Are you sure you don't have MultiSelect set to fmMultiSelectMulti?
It is set to fmMultiSelectMulti
As illustrated in the image above - the user can select from any of eight choices - and what ever they select in the box is what needs to be copied to the clipboard
Last edited by JJFletcher; 10-17-2015 at 04:03 PM.
Obviously it will always pick the first row since you updated the rowsource and then used my code. Use the Listbox's Click event to copy the row selected.
If your are going to use mulitselect, then a different solution is needed.
Here is my multiselect method. I used the Exit event to run the copy.
Please Login or Register to view this content.
Have changed the Post header - because the need has changed from the Radio buttons to a dropdown list that the user will select instead and the data will show as it does in the text box. Any Idea's or samples I can review?
Best Regards,
John
Hi JJFletcher,
Sorry, but I am not exactly sure of your requirement and/or if your workbook contains a Userform.
For the lack of same as explained above, I hope that the attached Workbook will suffice.
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks