I am attaching a sample macro-enabled spreadsheet.
It has 2 Worksheets: Recipe Calculations & Recipes Entry
There is a custom ribbon tab named Recipes (It should show up after the Developer Tab) that contains a button for searching for a recipe name (or a portion of a name).
When the button is pushed a Userform opens with a Search textbox and a Listbox that brings up any recipes that match the search.
I added another button called Go To Recipe that I do not know how to write the code for.
The ListBox supplies the location of the recipe in column 4, but I don't know how to use that information to get the user to that location.
Can someone help with that?
Bookmarks