+ Reply to Thread
Results 1 to 3 of 3

refresh Combobox without reloading userform

  1. #1
    Forum Contributor
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    100

    refresh Combobox without reloading userform

    Hi

    I'm using this name manager to select the drop down list for my combobox:

    Please Login or Register  to view this content.
    and for my combobox in userform1 I'm using
    Please Login or Register  to view this content.
    and the add Button is:
    Please Login or Register  to view this content.
    I added Userform2, so that the user can add to the combolist without closing userform1

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    This works but each time the user adds a new item to the list, the userform have to be reloaded to see the new item in the drop down list. Is there a way to refresh the list without reloading it?
    (Sorry I can't upload the excel file and when I made a example-file there was few errors that I couldn't figure them out)

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,124

    Re: refresh Combobox without reloading userform

    Try adding this after the line in your code that shows userform2. I can not see that in any of the code you posted though.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    05-05-2020
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    100

    Re: refresh Combobox without reloading userform

    Yeah I put this to open userform2
    Please Login or Register  to view this content.
    It worked\( ^o^ )/

    Thank you

+ 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. Reloading and limiting comboboxes in UserForm
    By TemplarDrake in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2020, 09:59 AM
  2. How to refresh dependent combobox list on focus on a userform
    By bevc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-03-2016, 11:32 AM
  3. [SOLVED] Need to Refresh Label in Userform after choosing an Item in a Combobox
    By sdemps in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2013, 11:06 AM
  4. [SOLVED] send data from userform combobox to userform combobox
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-18-2013, 04:47 PM
  5. [SOLVED] Refresh Userform ComboBox Data Source
    By lday75 in forum Excel General
    Replies: 1
    Last Post: 08-23-2012, 01:23 PM
  6. Refresh UserForm to display data that is linked to combobox selection
    By alter54 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2012, 01:30 PM
  7. saving and reloading the contents of a userform
    By bennyob in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-07-2005, 11:20 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