msgbox disappear until right value entered

Hi,

looking for vb code where a msgbox only disappears when value "Finished" is entered in cell A1. Until then, the msgbox stays active

Thanks

Hi biznez,

Try the attached sample workbook which should help you get started. It displays a 'Faux' MsgBox that disappears when cell 'A1' contains 'Finished'.

You don't have to use my UserForm, you can use your own. The UserForm has to be opened 'NonModally'

Please Login or Register  to view this content.

The code that does the heavy lifting follows:

Please Login or Register  to view this content.

Lewis

Originally Posted by LJMetzger

Hi biznez,

Try the attached sample workbook which should help you get started. It displays a 'Faux' MsgBox that disappears when cell 'A1' contains 'Finished'.

You don't have to use my UserForm, you can use your own. The UserForm has to be opened 'NonModally'

Please Login or Register  to view this content.

The code that does the heavy lifting follows:

Please Login or Register  to view this content.

Lewis

Thanks LJMetzger ...ill look into this

I would think it would be easier to just set the UserForm ShowModal property to false, which will allow work to be perfomed on the sheet while the userform is still visible. Then trigger an unloading of the userform by worksheet_change event when A1 = Finished.