+ Reply to Thread
Results 1 to 2 of 2

change User Form Labels based on combobox

  1. #1
    Registered User
    Join Date
    08-29-2016
    Location
    hillsboro, NH
    MS-Off Ver
    11
    Posts
    4

    change User Form Labels based on combobox

    I have a user form with a combo box that has a mist of dates. When the user selects the date i would like the labels to change.

    EX: the user selects 6/18/2018 and the labels change to 6/18/2018, 6/19/2018, 6/20/2018 etc.
    EX: the user selects 6/25/2018 and the labels change to 6/25/2018, 6/26/2018, 6/27/2018 etc.



    is there some code that will make this happen?

  2. #2
    Forum Contributor
    Join Date
    09-21-2009
    Location
    Belgium - Mechelen
    MS-Off Ver
    Office 365 - version 2310
    Posts
    278

    Re: change User Form Labels based on combobox

    In order to let the forum members and experts help, you'll need to provide more information.
    A sample workbook with a userform, additional comments would help to understand the problem you're facing.

    What labels need to be changed? the combox's or the cell labels in a sheet?
    Even a little help can be a big help !!
    1. A sample workbook says more then words. Add problem description and solution so we can understand the problem.
    2. Your appreciation is accepted by clicking the star "Add Reputation" at the lower left of the post.
    3. If your problem is solved, mark it as [SOLVED]: See "FAQ : " https://www.excelforum.com/faq.php
    4. Use [CODE] [/CODE] tags to illustrate your code: see here

+ 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] populate user form combobox based on dynamic range
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2015, 09:22 PM
  2. [SOLVED] Change Labels in Userform based on selection in ComboBox
    By johnw993 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 01-03-2013, 10:52 PM
  3. [SOLVED] Populate user form based on combobox choices
    By zardof in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-20-2012, 11:08 AM
  4. Calling a user form initialize sub when entering the form to populate combobox...
    By regupnorth in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-02-2012, 07:24 AM
  5. Clearing ComboBox on User Form after change
    By jeffreybrown in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-07-2011, 10:53 AM
  6. Transfer User form data to a worksheet w.r.t. combobox item on the form
    By nm766 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2011, 12:43 PM
  7. transferring combobox value from one user form to populate combobox on another
    By smartphreak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2010, 10:12 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