How to Extract Data on Userform

[tariqjahangir]

Dear Excel Forum Expert Please Help Me I want to ( Extract ) Data on Userform from ( Sheet Home ) to Extra Combow Boxes ( MCC,MISFER,UBM ) and Display Data From( Sheet: Data ) Colum H2,I2,J2 Which Name are iam Indicated With Redmark ( I think those people understand what i mean to say )
Thanks
Screenshot Attached: (Excel Datasheet and Jpeg Image )Attachment 483529

unnamed.jpg

[alansidman]

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[DanzaNZ]

Hi tariqjahangir

Its better to see codes rather than a picture, but i think you might want to use something like these....

Please Login or Register  to view this content.

You first need to set an "activecell" by searching the sheet for a value which is on the same row as the data you want on those textbox's.

Once your search finds the value, that cell becomes the "activecell".
You can then use the above code to fill the textbox with values left or right of the activecell by changing the (0,1) values to suit.

hope this helps....

[tariqjahangir]

Dear sir,
I Have Attached Excel File