How to get the value from combo box and search in the excel sheet.

[somani123]

Hello Everyone!!

I need your help. I am quite new to the VBA.

I am working on the report.In this report I want the user to select the weekday(Monday / Tuesday/...) or the month. Whatever the user select the value should be search and display.

Detail description is given in the attached file with screenshots.

Kindly help on this.

Thanks in advance.

Kindly find the attached report created in VBA.

[Leith Ross]

Hello somani123,

It is unlikely you will find someone to recreate your work from a picture. It takes too much time and the results are not likely to match what you have alreadycreated.

To help you with this problem, you would need to post your workbook. We need to see how the data is arranged, what formulas you are using, etc. Otherwise, we are just guessing at what you need.

Please provide before and after examples of your data along with any notes you would like to include.

If your workbook contains any sensitive information, please redact that information before you post.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

[somani123]

Thanks for your reply.

I have attached the original file again.

Can anyone help on this?

Thanks in advance.

[Leith Ross]

Hello somani123,

You have added a control to your VBA project that is not supported in Excel 2007 and later.

People are not likely to import these older controls in their computers. You should used a newer version of the control.

[somani123]

Hi,

Thanks for your reply..

Kindly find the attached unprotected find.

And anyone can help on this.

Thanks a lot.