How to 'update' or DoEvents for a userform being unhidden from another userform

[Oliver Dewar]

Hi Again Guys!

I have two userforms. One is modal (modal1) and one is modeless (modeless1) - the modes may not be relevant but just in case there it is.

Modal1 opens first and the user clicks on a combobox and selects a certain value to hide modal1 and show modeless1. Modeless1 then works like a refedit control and allows the user to select a cell and therefore all the data in that row.

The user then clicks a button on modeless1 and modeless1 is hidden (modeless1.hide) and modal1 is shown (modal1.show) with the relevant data inputted.

This all works perfectly.

The only thing is that the user doesn't see the changes in the data until they click away from the combobox and this is a bit confusing because initially it appears that the update didn't work (before they click away).

Is there a way to make modal1 run a macro on .show (initialize won't help in this case... I think) or to send a DoEvents type command from Modeless1 to modal1 when it hides itself and shows modal1?

Thanks in advance.

Oliver

 

[xenou]

Try adding DoEvents to the Activate event for modal1.

 

[Oliver Dewar]

You've nailed it xenou.

You guys are my heros!