Hello,
I have a textboxin one tab of userform and a listbox in other tab.
I want that whatever text is written in text box is stored in the listbox of other tab.
Any help will be appreciated
Something like
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) With Me .ListBox1.AddItem .TextBox1 .TextBox1.Value = Empty End With End Sub
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Thankyou, Roy for reply.
I am extremely sorry for I provided some wrong information. Actually I just modified the userforms a bit.
Now,there are two userforms. The userform containing the textbox is launched from another userform and the launching userform has a combobox(not listbox) in other tab.
Now, how to populate this combobox with the textbox entries.
Hope,you will help me out
You are making work for yourself. One userform with a Multipage is the best way to do this
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
I kow roy but the situation demands so.
Please help me out.
Well I am stuck due to the above mentioned problem.
Any help will be greatly appreciated.
I can't see any situation that would demand two userforms. You need to attach an example workbook
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks