Search and select through listbox.

[shinumon]

I have a sheet1 with columns A to H with different data like Bill number, date, account head, customer name, amount etc. Column B contains date.
My userform1 contains a textbox1, command button1 and a listbox1. When I enter a date in the textbox1and click the command button1,all the rows for that date from column A to H should be populated on the listbox1.
Again if I select a row in the listbox1, the actual row in the sheet should get selected..
Is it possible. I am new to Vba and couldn't work it out.

 

[My Aswer Is This]

I have a sheet1 with columns A to H with different data like Bill number, date, account head, customer name, amount etc. Column B contains date.
My userform1 contains a textbox1, command button1 and a listbox1. When I enter a date in the textbox1and click the command button1,all the rows for that date from column A to H should be populated on the listbox1.
Again if I select a row in the listbox1, the actual row in the sheet should get selected..
Is it possible. I am new to Vba and couldn't work it out.

That can be done. You said: the actual row in the sheet should get selected..
Now what?
I suspect you want to do more then just selecting the row.

 

[shinumon]

Can I have the code for this

 

[My Aswer Is This]

I'm going to leave this to someone else to help you.
I was hoping you would say what you plan to do after selecting the row.
But since right now all you want is to select the row.
To select a row that sheet must be the active sheet or we must use a Goto Function
And if you just click on a row in the listbox some how the script has to know what row that particular row came from.
And your talking about a Multicolumn listbox with 8 columns.
So:
This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.

 

[shinumon]

Ok. Thanks