Hi,
I have a userform that dynamically hides and unhides columns based on the selections in a listbox. .Selected(0) is "Show All" and the following list items refer to the other columns. I would like to automatically deselect "Show All" when any other list item is selected. Adding .Selected(0) = False into the With nest obviously sends it into a loop and crashes Excel. I know it's simple but I'm struggling to figure it out.
Thanks in anticipation
Please Login or Register to view this content.
Hello radddogg,
You should use a CommandButton to run the macro. This will also let the user edit the selections before they are applied.
Here is an example where the code has been moved to a command button named "ComanndButton1" on the UserForm.
Please Login or Register to view this content.
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,
I tend to agree about using a button but purely for information you can use a control variable. Add to the top of the form module
and then amend your code toPlease Login or Register to view this content.
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
This deselects all other selections when you select All and deselects All when you select any column.
Please Login or Register to view this content.
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.
Hi,Originally Posted by Leith Ross
Hello radddogg,
You should use a CommandButton to run the macro. This will also let the user edit the selections before they are applied.
Here is an example where the code has been moved to a command button named "ComanndButton1" on the UserForm.
Please Login or Register to view this content.
It previously was on a command button but I wanted to simplify the form and make it more intuitive. The current effect works very well. I just wanted to remove the need for the user to have to deselect "Show All" before their selections take place, cheers.
Hats off to you Alpha. This is exactly what I was looking for. Thank you for not only solving my problem but also helping me increase by knowledge
+rep
Thanks for the suggestion, I went with Alpha's solution in the end, cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks