vba userform search

[akshaygaru]

Hi, I am begineer in vba and finding very attracted to vba and excel.

I have a column A with multiple entries, however some entries are repeated due to different criteria's in column B, and have some entries in column C,D,E. Now, i want to have a userform which will have input as a text from Column A , the userform would carry search from column A and have combox box list in adjacent option to list all the entries in Column B with similar text in Column A. Then on selecting from the list and on clicking search button, will display all the entries in Column C,D,E. Matching criteria of Column B (of course Column A is already specified). The most important to note is column B entries may be same or different. Therefore the entries in column B cannot be grouped.

Can anybody help me in this. Thanks in advance

 

[royUK]

See my DatabaseForm example '

DatabaseForm example

 

[akshaygaru]

See my DatabaseForm example '

DatabaseForm example

Can you pls share the vba code for this example. Appreciate your support. Thanks

 

[royUK]

The code is available. There is no password on the basic form