How is it possible to fill in data from a textbox into a selected row in a listbox
Hi,
I have a excel vba userform problem.
I have a listbox that is automatically filled with data in two columns through a lookup function from a worksheet. That works fine. But now I want to fill the third column with data through a text box, but only in the rows I have selected in the listbox.
My code so far is:
Please Login or Register to view this content.
The number I want to insert into the listbox appears, but not in column 3 in the selected row(s).
Thanks,
Erlend
Last edited by vbastarter14; 06-02-2014 at 11:10 AM.
Thanks for the information :-)
Hello vbastarter14,
Is this ListBox on a Worksheet or VBA UserForm?
You say it is filled automatically. Does this mean you have assigned a Range to the RowSource property?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi,
Thank you for your response.
The listbox is on a vba userform.
And the code for filling the userform is connected to a combobox which has the lookup function. The code looks like this:
Please Login or Register to view this content.
Thanks,
Erlend
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks