UserForm to Search Workbook

[BrendanDixon]

Hi All,

I have a userform called "Search" I have a textbox called "TextBox1"
and a button called "CommandButton1" I would like to have some programming that what ever I type in the text box and then press the button it will go to the cell with with the same text. while keeping the userform on top. if I click on the button again it will go to the next value of the text in the text box. My workbook has multiple sheets and I want the search to ignore Case differences.

Does anyone know how to do this and could you please help me. I do not know where to start with this.

 

[al_b_cnu]

Hello Alan, thank you for your reply.

The trouble is, that does not fit in with the functionality of the userform. The user is forced to scroll through a long list of columns and pick and choose using a listbox. It does not make the best use of the space either.

I have an example of your way vs my proposed way:

Also, the column headers shown should be selected/deselected after the results appear, they user shouldn't be forced to choose them before searching. The functionality you have provided is the reverse of what is required.

Does this make sense?

Amended design proposal: https://www.dropbox.com/s/co8hljozxca3div/Copy of AltBKContacts.xlsm?dl=0

Hi Sheepdip,
ok, comments taken on board, have amended the code to include the checkboxes, note that I've renamed these to simplify the coding. The checkboxes idea is good in that the user can see at a glance which fields are displayed, however I'd have liked to have created a (hidden) sheet for the listbox results, allowing us to show headings. All the checkboxes are initially ticked, and the search box will be hidden if there are NO checkboxes ticked.
The code will only search ticked headings.
https://db.tt/2GAIjLek9W

 

[TheJay]

Hello Alan, thank you for the update. That works quite well!

I have updated the design and enabled all tickboxes by default. It would be better if the search box was always displayed rather than being hidden now that they are all selected by default. I'm not sure how this can be implemented.

https://www.dropbox.com/s/co8hljozxca3div/Copy of AltBKContacts.xlsm?dl=0

Could you please add that functionality to the 'Update' tab though, so it only shows the buttons once a selection is made from the combobox?

 

[TheJay]

Hello Alan, I hope you are well. I notice that you have not replied for some time. Could you please get back to me when it is convenient? Thanks.