Tag Archives: Excel Search

Adding a search function to a UserForm

We will need to know where the data we want to search is held, in this example it’s in the tab named ‘OrderFormData’ in columns B and C. Because INSTR is case sensitive, the way to be sure we don’t miss any text capitalisation changes in the data, we convert each to ‘virtual’ upper case. […]

the webdesigner group security shielf
the webdesigner group logo

Close Button

Web Page Design by

The Web Designer Group