+ Reply to Thread
Results 1 to 4 of 4

userform command button to "find" specific string?

  1. #1
    Forum Contributor
    Join Date
    07-19-2019
    Location
    Illinois, USA
    MS-Off Ver
    365
    Posts
    164

    userform command button to "find" specific string?

    The overall goal of this is to create a sort of "Contents" Shortcut list that can be put on a userform, and the user can "click" a button on the userform to "go to" the location of that title in the worksheet.

    For example, the following code would take you to cell A1218:

    Please Login or Register  to view this content.

    But! Instead of taking me to a specific cell, I would want it to take me to a cell that had the words "CHAPTER 10", wherever that cell may be located on the active worksheet

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,168

    Re: userform command button to "find" specific string?

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    07-19-2019
    Location
    Illinois, USA
    MS-Off Ver
    365
    Posts
    164

    Re: userform command button to "find" specific string?

    perfectly solved

    Thank you!

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,168

    Re: userform command button to "find" specific string?

    Glad I could assist...Tx for rep +

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Add "comments" box pop up when the user "mouses over" an active-x command button.
    By mmcap64 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-09-2020, 09:32 PM
  2. Userform - problem command "save" (i.e. Edit/modify) button
    By mariec_06 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-20-2015, 01:13 AM
  3. Need help creating specific "add-row" macro using a command button
    By rmtreadw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2014, 10:01 PM
  4. Create a Command Button to "Save As" and "Close" an Excel Workbook
    By thedunna in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-26-2013, 05:38 PM
  5. Userform to store "option button value" in specific column
    By Luis21 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2013, 12:48 PM
  6. Replies: 0
    Last Post: 12-10-2012, 04:34 AM
  7. How to change a Command Button caption from "Enable" to "Disable"?
    By Infinity in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2007, 12:14 AM

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