User edits of combobox entries in Excel 2007 VBA user forms

[phudgens]

I am using Excel 2007 VBA code to load data into a combobox located on page 2 of a multi-page form which in turn is located on a user form. Depending on what the user enters in textboxes on page 1 of the multi-page form, the combobox is loaded with a calculated number of lines. The user then needs to edit various of those entries in the combobox, without adding new entries or deleting any entries. Even though I can select entries in the combobox which then appear in the display, and enter new values in the window, those new values do not become permanent. Is there a way to allow users to change/edit entries in a combobox in Excel VBA user forms?

Thanks for any help,
Paul Hudgens
Denver

 

[Jerry Sullivan]

Hi Paul and Welcome,

How are you populating the ComboBox list you currently have?

Based on your desire to allow the user to make changes to the list which are saved for the next session, I'd suggest you store your intial list in a named range in your workbook. Then as the user adds new values, you add those values to the named range in your workbook. As long as your workbook is saved with the changes, the list will retain the additions.

You can search this site for examples of Dynamic Ranges, which allow your named range to automatically be resized when you add items to the list.

 

[phudgens]

Thanks for your reply. I do intend to give the user the option of saving all entered/edited data. What I need to do though is harvest the entered/edited data and create an external text file which is then fed into a software program. I've got working code to do all this, except for the editing combobox entries part. I had though that there would be a way for the user to edit entries in the combobox, once it has been populated. I had assumed that that was what the display window was for on a combobox - but it doesn't appear to work that way. I can probably make it work via a InputBox triggered by the _Click event - I had just hoped that there would be an in-line, on-the-fly, way of doing it. Thanks for the help.