+ Reply to Thread
Results 1 to 5 of 5

Dynamic Independent ComboBox - Populate TextBox

  1. #1
    Forum Contributor
    Join Date
    10-30-2014
    Location
    Pretoria, South Africa
    MS-Off Ver
    Office 365
    Posts
    111

    Dynamic Independent ComboBox - Populate TextBox

    Good Morning,

    I hope this e-mail finds you well.

    I have 3 dynamic independent ComboBoxes code that is working fine, however I am clueless once selections have been made in the comboboxes how to populate a textbox.

    In the attached excel example, I would like the textbox to be populated with column D once the final section in combobox 3 was made.

    I think it is fairly straight forward for the geniuses on this forum.

    I thanks you in advance for any help!

    Thanks,

    Ray
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,136

    Re: Dynamic Independent ComboBox - Populate TextBox

    Please Login or Register  to view this content.
    Attached Files Attached Files
    David
    (*) Reputation points appreciated.

  3. #3
    Forum Contributor
    Join Date
    10-30-2014
    Location
    Pretoria, South Africa
    MS-Off Ver
    Office 365
    Posts
    111

    Re: Dynamic Independent ComboBox - Populate TextBox

    Morning,


    Thank you for you reply, much appreciated.

    I have been testing it and it seems that there is a slight error on the code. Some of the options selected do populate the textbox with the username and some don't.

    Do you perhaps know why this will be the case?

    I have inserted a picture showing examples of options that do not populate the textbox.

    Thanks you!!!

    Picture1.png

  4. #4
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,136

    Re: Dynamic Independent ComboBox - Populate TextBox

    They do fill the textbox on my machine, so I think it's probably the date format that causing it.

    In the Combobox3_Change event, at the Debug.print, make sure the two dates printed in the immediate widow match. If they don't, adjust the Format function inside the quotes until they do.
    1060188.jpg

  5. #5
    Forum Contributor
    Join Date
    10-30-2014
    Location
    Pretoria, South Africa
    MS-Off Ver
    Office 365
    Posts
    111

    Re: Dynamic Independent ComboBox - Populate TextBox

    Hi thanks for the quick reply, I have changed them to match and is working perfectly now.

    Thanks once again!!

+ 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 textbox from multiple combobox entries
    By mdex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2014, 08:28 AM
  2. Populate TextBox based off ComboBox selection
    By ladams41 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2014, 01:24 PM
  3. [SOLVED] Excel Userform: Populate other controls (i.e. textbox & combobox) based on combobox select
    By MileHigh_PhD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2013, 04:50 PM
  4. Populate textbox from a combobox (Solved)
    By age in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-02-2012, 07:14 AM
  5. Combobox populate textbox
    By samtwilliams in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2007, 10:27 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