Hello,
I have Combobox on Userform, in which I have listed days of month. At the end of Userform initialize event, my code ends with :
This ofcourse sets Listindex back to first day, but I want Listindex to remain where It was last If I close and reopen Userfom. How can I correct that ?
Please Login or Register to view this content.
Don't close the userform. Just Hide it and then show it again. The Initialize procedure won't re-run if you show a hidden userform.Originally Posted by Lukael
Hello,
I have Combobox on Userform, in which I have listed days of month. At the end of Userform initialize event, my code ends with :
This ofcourse sets Listindex back to first day, but I want Listindex to remain where It was last If I close and reopen Userfom. How can I correct that ?Please Login or Register to view this content.
UserForm1.Hide
UserForm1.Show
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks for suggestion AlphaFrog,
but Userform1.Hide doesn't update data in my Userform, and that's what I need. I do that with Unload Me from "refresh" Cmdbutton, and that's why Listindex jumps back to where It ends in code, initialize event must re-run.
I'm trying to get last listindex.value simply because It would look better to stay where It is, after performed update of Userform.
Last edited by Lukael; 03-15-2014 at 05:03 PM.
The code you have to populate the listbox in the initialize procedure could be duplicated in the Refresh command button procedure. No need to unload the userform just to reuse the initialize procedure.
If you meant that with starting Userform1.hide and ended with Userform.Show, It doesn't work.
Besides listbox to update, I have checkboxes and textbox too. Copied all code to refresh button and removed Listindex = 0.
Can you post both your initialize and refresh procedures. I'' show you what I meant. No need to hide and show if all you want to do is repopulate a list box.
yes sure, here It is
Initialize :
Refresh :Please Login or Register to view this content.
But under combobox_change event I have more code for ticking checkboxes on userform, need that too ?Please Login or Register to view this content.
I don't know.But under combobox_change event I have more code for ticking checkboxes on userform, need that too ?
My point was to just repopulate the list box from the refresh command button instead of unloading the user form.
Please Login or Register to view this content.
I tried, but I get error.
Maybe you should check this attached sample Userform, If you have some time ?
Consider this last last request, I am getting a feeling that this isn't a simple task.
Even with your example workbook, I don't appreciate what the Refresh button is refreshing.
Another suggestion is to have a Populate_Listbox procedure that both the Combobox_Change procedure and the Refresh button call as needed.
Please Login or Register to view this content.
hi Alphafrog,
tried your code but I receive error "invalid use of null". Could you try on my sample and post It back to me ?
Hi again,
I managed to get this code working, It needed some minor changes. To populate listbox is really best option for me. Thanks for help !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks