• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Combo box Requirement

P

Prabhu9teen

New Member
Hi All,

I'm working on a new project on customer database, in this there will be a common excel sheet (Assuming it as a database) placed in a shared location.
(Example: C:\Users\Prabhu\Desktop\AP\828.xls.

When i make any input in the BP code combo box, its corresponding BP name should be displayed in the BP name combo box.

My macro should fetch the details from that excel sheet which is placed in the above path.

This is the only part which is pending from my end to complete the macro..

Thanks for your help in advance!


upload_2015-1-14_12-43-37.png
 
Hi ,

The reason to use a combo box is so that the user can make a selection from a list ; if you are going to look up the BP code in an external workbook , and retrieve the associated BP name , what is the purpose of using a combo box for the BP name ?

All you need to do for displaying the associated name is use a VLOOKUP.

Narayan
 
Thanks for the response Narayank... the reason for using combo box for BP name is to work other way round. in some cases people might not aware of BP code, in that case people can choose the BP name so that BP code will be populated in the combo box.
 
Problem here is, i'm doing this project using outlook vba, hence can you let me me know how to share this vba content from Outlook?

Please refer below screenshot!

upload_2015-1-14_14-20-32.png
 
Hi ,

You need not upload your working file ; what you can do is just insert the two controls , insert the lists for both combo boxes in the same file in a separate tab , and upload this sample file.

Narayan
 
Hi ,

See the attached file ; I have not used the FIND button. Selection from the combobox itself initiates the search for the matching entry.

Let me know if you need any changes.

Narayan
 

Attachments

Hi Narayan,

I have another query related to combox box, could you please let me know how to display the unique items in the combox box. i have attached the sample file for your reference.

Your kind help is much appreciated!

Thanks for your help in advance :)
 

Attachments

Thank you once again for your help! Before generating this macro i may need to add a code to do sorting in order to generate this code without bugs. Am may right Narayan?

Since i'm an intermediate in VBA code and i just started doing some project, would you please help me with some useful websites to get the in-depth concepts of VBA codes?

This might be a great help for me!!:)
 
You must log in or register to reply here.
Back
Top