Paste Clipboard into Userform Textbox

I created a command button on my userform to "paste" the clipboard to a text box. Then I hit a Search button to look up the part number and fills all the other text boxes on the form. The paste button works fine but the "search" button acts as if the text box is blank. Yes, ctrl+v works fine but I want a button. Below is my code and of course it's too simple of a solution to work!

Please Login or Register  to view this content.

Thank you for the suggestion. Maybe I'm missing how to use what you provided but I'm not wanting to paste the text on the clipboard into a cell of a sheet. The textbox on the Userform is where I enter a sku....such as 6308-2pk and then I press the "Search" button and it will fill the rest of the Userforms text boxes, based on the pasted text/sku, with data from my inventory sheet. There are 40 different textboxes on the Userform that are filled based on the pasted sku. I have over 1,000 skus. To further explain....The backend of my business is ran on a website and on the website I have to copy a sku by using ctrl+c and then paste into the sku box of the Userform using ctrl+v. Then I press the "Search" button to look up the sku's particulars such as cost, margins, fees and many other bits of data about the sku. I'd rather just press a "Paste" button.

The Userform works fine using ctrl+v but I want it simpler, for me, by just pushing a button to paste and then pressing the "Search" button as usual. As mentioned, if I use the code I provided initially or the code you provided in your sample workbook then my "Search" button seems to only see it as a "blank" box even though the text pasted with the new button is visible. I don't even get my error message "P/N doesn't exist".

I do appreciate the help.

Thanks,
Andy

Your latest file is exactly what I need it to do. I used your code from the "Paste Part #" button added to my "Paste" button and changed my search box name accordingly. Like I've already been able to do, it WILL paste the clipboard value into the search text box, but when I hit the "Search" button, nothing happens.

To go further....using this part number "6308-2pk" and pasting it using the Paste button then it will paste in the search box BUT nothing populates when the "Search" button is pressed....it's as if the search box is blank. However, if I backspace over the "k" and retype the "k" then it recognizes the whole part number and populates the other textboxes accordingly when the "Search" button is pressed.

I have searched and searched to resolve this issue and this is as close as I can get. I think I understand that we're changing the clipboard to a DataObject so it can see the clipboard as "text" rather than an image?

Please Login or Register  to view this content.

What in the world am I missing?

Andy

I've tried to reduce the file by copying the applicable sheet to a new workbook but it's still 5.39mb. I deleted all the 900+ sku's and only have a 4 test sku's and deleted all formatting all the way down and to the right. 5.39mb is the smallest I could get it for some reason. I'll work on it more tomorrow to reduce it and hopefully get something useful for you to work on.

I appreciate the effort and understand on needing the file.