Results 1 to 9 of 9

VBA for Navigation to sheet from ListBox on Userform

Threaded View

LKERN VBA for Navigation to sheet... 08-01-2019, 07:24 PM
bakerman2 Re: VBA for Navigation to... 08-01-2019, 08:19 PM
LKERN Re: VBA for Navigation to... 08-01-2019, 08:34 PM
bakerman2 Re: VBA for Navigation to... 08-01-2019, 08:43 PM
bakerman2 Re: VBA for Navigation to... 08-01-2019, 08:46 PM
LKERN Re: VBA for Navigation to... 08-01-2019, 09:30 PM
bakerman2 Re: VBA for Navigation to... 08-01-2019, 09:34 PM
LKERN Re: VBA for Navigation to... 08-01-2019, 09:37 PM
bakerman2 Re: VBA for Navigation to... 08-01-2019, 09:39 PM
  1. #1
    Forum Contributor
    Join Date
    11-08-2017
    Location
    Murfreesboro, TN
    MS-Off Ver
    MS 365
    Posts
    168

    VBA for Navigation to sheet from ListBox on Userform

    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?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA send sheet table to listbox on userform
    By DanzaNZ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2018, 07:44 PM
  2. Listbox filtering by combobox and listbox navigation
    By bufoss in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2015, 02:36 PM
  3. [SOLVED] if anything in listbox select first item, if listbox empty do nothing (listbox in userform
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2015, 12:49 PM
  4. Transfer Data From One Userform Listbox to Another Userform Listbox with 11 columns
    By sparkoft in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-18-2013, 10:54 AM
  5. Listbox to Listbox, no duplicates & submitting same UserForm data for each Listbox entry.
    By jamieswift1977 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2012, 12:18 PM
  6. Userform Listbox using an active sheet
    By steve.sparti@gmail.com in forum Excel General
    Replies: 0
    Last Post: 03-01-2006, 04:25 PM
  7. Listbox navigation
    By Delano in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2005, 12:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1