I'm currently building a userform for work so that my colleagues can add suppliers details and search them too.
I am currently struggling to write a code for the search button, so that when either the textboxes or checkboxes are selected or entered - the results are listed in the listbox below.
The last time I used Excel for something like this, was years ago in school - so my memory is being tested.
I am using VBA in excel to construct my userform. I currently, dont have any code for what i am looking for as i have been unsuccessful for when i am trying to make it work. Basically, i have a search command button, which when textboxes or checkbox are filled in, once clicked on it will bring up results in the list box displayed below. I have 5 textboxes and 8 checkboxes. I have a datasheet which the data gets added to when the user enters the relevant information and clicks the add button.
I am currently struggling to write a code for the search button, so that when either the textboxes or checkboxes are selected or entered - the results are listed in the listbox below.
The last time I used Excel for something like this, was years ago in school - so my memory is being tested.
I am using VBA in excel to construct my userform. I currently, dont have any code for what i am looking for as i have been unsuccessful for when i am trying to make it work. Basically, i have a search command button, which when textboxes or checkbox are filled in, once clicked on it will bring up results in the list box displayed below. I have 5 textboxes and 8 checkboxes. I have a datasheet which the data gets added to when the user enters the relevant information and clicks the add button.
