LinkBack URL
About LinkBacks
how fill listbox (ActiveX) based combobox (ActiveX)
i need choise value in combobox (ActiveX), then listbox (ActiveX) show data from tab "OrigData"
Please Login or Register to view this content.
how fill listbox (ActiveX) based combobox (ActiveX)
i need choise value in combobox (ActiveX), then listbox (ActiveX) show data from tab "OrigData"Please Login or Register to view this content.
Hello elsg,
You have password protected your workbook. You need to either post the password or a copy of the workbook with the protection removed.
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!)
sorry, i haven't password in file or tab.
Put this code in sheet AleVBA's worksheet module.
PS To get started you'll need to activate AleVBA which you can do by selecting the first sheet then going back to AleVBA.Please Login or Register to view this content.
If posting code please use code tags, see here.
Hi nori my combobox is filled, but my ListBox1 not fill, why happening?
Oops, forgot one more thing, you need to change the no of columns in the listbox.
Currently that's set to 0, add this to set it to 13.
This is where that code would go.Please Login or Register to view this content.
Please Login or Register to view this content.
i have othe question.
how autosize columns?
my format time in tab nos display same in columns(B,F,J) inside listbox.
how to correct this format hours in the listbox?
I'm afraid there's no autosize for columns in a listbox, you'll need to set the column widths yourself either in design mode or with code.
ok, but how i format tima (hh:mm) in columns(B,F,J) inside listbox?
You'll need code for that, can't post anything specific right now but it would look something like this.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks