Hi Guys,
This is very challenging to me not for you, I am learning VBA just now....
I have excel sheet which has a lot of data in it. I am attaching a excel sheet with developed user form.
link for excel sheet.- Free Excel\VBA Help Forum
In the user form i have given some options, features i need to explain those.
option buttons (AND/OR)
when we are selecting multiple list boxes, with these options macro can search according to these options it means- "AND" is for two conditions should match, "or" means any one condition should match.
Check boxes (Exact match / Like match with *)
Exact match means given condition should match exactly. Like match means condition can be like it means partial match.(this match will be done by * symbol)
Combo boxes / List boxes
In the developed user form i have shown 2 combo boxes and 2 list boxes those are just showing purpose only. Normally the user form should display 1 combo box and 1 list box. but when we click on '+' button macro should display the another combo box and list box and also "-" button. with '-' button we can clear the new combo box and list box.
Combo boxes should contain some criterias as given in the excel sheet headings.
In List boxes user will type the data, for what he wants to search.
Command Buttons
with command button 3 another combo box and list box should display.
with command button 1 macro should search the sheet and display the result in sheet2,
after searching sheet 2 should open automatically. total row would be display in sheet 2 if the condition satisfies in a single cell.
I need a code for this macro..
Please let me know if any queries.
Thanks in advance....I am waiting for the reply...
PRB.
This is very challenging to me not for you, I am learning VBA just now....
I have excel sheet which has a lot of data in it. I am attaching a excel sheet with developed user form.
link for excel sheet.- Free Excel\VBA Help Forum
In the user form i have given some options, features i need to explain those.
option buttons (AND/OR)
when we are selecting multiple list boxes, with these options macro can search according to these options it means- "AND" is for two conditions should match, "or" means any one condition should match.
Check boxes (Exact match / Like match with *)
Exact match means given condition should match exactly. Like match means condition can be like it means partial match.(this match will be done by * symbol)
Combo boxes / List boxes
In the developed user form i have shown 2 combo boxes and 2 list boxes those are just showing purpose only. Normally the user form should display 1 combo box and 1 list box. but when we click on '+' button macro should display the another combo box and list box and also "-" button. with '-' button we can clear the new combo box and list box.
Combo boxes should contain some criterias as given in the excel sheet headings.
In List boxes user will type the data, for what he wants to search.
Command Buttons
with command button 3 another combo box and list box should display.
with command button 1 macro should search the sheet and display the result in sheet2,
after searching sheet 2 should open automatically. total row would be display in sheet 2 if the condition satisfies in a single cell.
I need a code for this macro..
Please let me know if any queries.
Thanks in advance....I am waiting for the reply...
PRB.
