+ Reply to Thread
Results 1 to 3 of 3

Command Button/VBA that utilizes data validation list

  1. #1
    Registered User
    Join Date
    02-10-2021
    Location
    Barrie
    MS-Off Ver
    MX Excel for MS 365 MSO
    Posts
    5

    Command Button/VBA that utilizes data validation list

    Hello,

    I am looking for some assistance with a VBA that I am trying to use that is based off a data validation list.
    The goal is for the user to select the desired date from the data validation list and then us the command button to use a VBA macro to then bring the user to that section in the sheet.
    Additionally, all of these 'dates' will be on the same sheet, sheet1 lets say.

    I have attached a sample workbook as an example.
    Any help is greatly appreciated.

    Thank you!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,098

    Re: Command Button/VBA that utilizes data validation list

    Hello Jtr,

    See if the following does the task for you:-

    Please Login or Register  to view this content.
    I hope that this helps.

    Cheerio,
    vcoolio.

  3. #3
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,232

    Re: Command Button/VBA that utilizes data validation list

    Other way
    Please Login or Register  to view this content.
    Artik

+ 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] Copying ActiveX Command Button from master sheet to subsheets. command button code missing
    By popper08 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-13-2020, 10:15 AM
  2. Date validation on command button
    By stiggy77 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-16-2020, 01:37 PM
  3. Command Button w/ VBA code to reset Data Validation dropdown lists & manual entry cells
    By Dellpanther in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2019, 04:41 PM
  4. Replies: 2
    Last Post: 02-02-2016, 10:27 PM
  5. VBA code to create command button. Print all sheets then delete command button.
    By Declamatory in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-15-2015, 05:18 PM
  6. Select next/previous item from data validation list using Command Button
    By msn.niyasu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-09-2014, 07:26 AM
  7. Help with a formula that utilizes a drop down list
    By brandiemz in forum Excel General
    Replies: 3
    Last Post: 05-21-2011, 02:04 PM

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