Redraw problem with user form (but probably it is my code...)

[fabiospark]

I would like to present a problem I have but it seems I can't attach anything.
When I click on the attachment button, only a tiny empty line appears.
I have already uploaded a file in the attachments" page but here I see nothing.

Thanks.

Sorry, after I sent my post on, I can see the attachment, so let me explain my little problem
in the next post.

Thank you..

[fabiospark]

Hi,
I'm creating the userform you see but if, for instance, I select a value
in the dropdown list and then another one in the long combo,
you see what happens in the first photo. Even if I close the combo,
a piece of it remains behind the form.
(First picture)

And if I drag around the whole form you see what I get in the second picture


Any idea on where should I look to fix it?

I uploaded the workbook in the previous post. (Excel 2003)

Thanks.

[AlphaFrog]

Just a thought; if a procedure sets Application.ScreenUpdating = False and does it several times without setting it back to True, then the screen may not refresh properly.

[fabiospark]

Thank you for taking the time to look into my problem.

You were right: that was the culprit.

I tried and commented out alla the SU = false in the filtering and in the sorting subs
and I put one of them at the beginnig of the click events of each option and radio button
and of the combos. Then I put a SU = True at the end of each of the aforementioned events
and it seems to work flawlessly.

From that on I changed a little the way I call the different subs with different events.

To change the sorting of the long combobox list I'm reverting back to a combo instead
of the radio buttons. In the change event of that sorting combo I'm trying
to fire a simple

Please Login or Register  to view this content.

but I can't find a way
to dynamically build the string to put into the brackets of the run instruction: any help?

I'll try to attach the updated wb.
You can call the userform also doubleclicking into the FoodDb sheet.
I usually do it in the cell "AA3000" so I can see the filtered list behaviour.

Thanks.

fabio

[AlphaFrog]

You're welcome. Glad it worked.

Just to let you know; Appplication.Run is typically used to run external applications. You can call your other sub-procedures within your project by simply using the more traditional Call function e.g.; Call Group_Filtering. The Call command is actually optional. You really only need the procedure name.

To change the sorting of the long combobox list I'm reverting back to a combo instead
of the radio buttons. In the change event of that sorting combo I'm trying
to fire a simple

Please Login or Register  to view this content.

but I can't find a way
to dynamically build the string to put into the brackets of the run instruction: any help?

1.) Are you asking how to build a string or pass a string?

2.) if you are asking how to build a string, I don't understand what string you are trying to build.

[fabiospark]

...
Are you asking how to build a string or pass a string?

Yes, I probably should have said "pass" a string.

In the "sorting" combobox I can select among this list:

Alfabetico
BestMatch
Calorie
...

In the click or in the change event of the combo I would like
to call a different sorting sub according to the choice.

I named the subs: "Sorting_by_Alfabetico"; "Sorting_by_BestMatch"
and so on, so I am trying to pass a joint string made with the costant
part: "Sorting_by_" and the dynamic one: UserForm2.ComboBox3.Text.

I tried with chr(34) & "Sorting_by_" & UserForm2.ComboBox3.Text & chr(34)
but it doesn't work.
I also tried a few variations without success.

Again, any help will be welcome.

Thanks.

[AlphaFrog]

Please Login or Register  to view this content.

[fabiospark]

As you can see in the WB, I have already built the Case sub and I like it because it's quite clear
but I thought if it was possible to do the same with a single, dynamic call incorporating the text of the combo.
But I can go on with the Case one.

Thanks.

Now I'm trying to create a "Settings" sheet where to store the values of a few variables.
Looking for a way to populate the userform fields when launched, I learnt that I can't
disable userform events directly so I have declared a boolean flag at form level and I have put
a check of that flag in all the click (and eventually also the change) events of the controllers
on the uf to avoid to fire them also when populating the fields with VBA. And this seems to work.

Any advice on the best way to deal with the userform closing, both with an OK button and with
a cancel button or with the "X"?
With the OK I would like to write the value of combobox2 into the cell from where the form was launched
and the value of the quantiy into a cell on the same raw but a couple of colums to the right.
With the cancel or with the X I would do nothing or just pop up a warning, maybe with the buttons Yes or no.

Thanks.