I would like to check if there are any dynamic userform for excel 2007?
Current i have four different worksheet (East, South, West North) which contain client information. I have a userform and i can select which user form to filter the data. It work perfectly for the attachment file below
I would like to improve it.
If let say i would like to add one more factor to filter which is adding some places in the four different worksheet (East, South, West North)
Form Example:
East (Hongkong, China, Japan, Philipines)
South (Singapore, Malaysia, Thailand, Indonesia)
West (England, Germary, Italy, Spain)
North (North Korean, Russia)
You may refer below image
Do you think is it possible? Or any suggestion would be appreciated
that seems quite simple, where do you store your list, for the countries in each sheet?
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case. Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
Do you really need a UserForm displayed in which none of the hemispheres (N, S ,E or W) is selected?
In this case you need to rearrange all the controls on the Userform if the selection of the hemisphere (N, S ,E or W) is changed, to do that I'd make a sub that places all controls based on the actual selection.
Place each control relative to the previous one instead of using hard-coded .Left and .Top properties!
For all the different hemisphere selections I would use the same Frame, changing only the .text properties of the Checkboxes. A selection of the first Checkbox would need the selcted hemisphere to know which country is relly selected.
You're welcome to rate this post!
If your problem is solved, please use the Mark thread as resolved button
I did an Update on your Userform in order to show the Locations Frame (Frame4).
The code to show filtered data based on a locations selection is NOT implemented, you should be able to do that by yourself!
You're welcome to rate this post!
If your problem is solved, please use the Mark thread as resolved button
Don't create anotgher Frame!
Follow the way with using "OptionButton9.Visible = False", since you are setting the .Visible-Property to False in case North is selcted, you need to set it to True again whenver you want to see it!
You're welcome to rate this post!
If your problem is solved, please use the Mark thread as resolved button