Robert has attended:
Excel VBA Advanced course
UserForm Display
Hello,
Cheers for the course. It gave much food for thought. A question with regards to Userforms though (we touched on it in the course but never got time to actually answer it). I understand that the 'ShowModal' property can be amended so that the user is given access to the Excel spreadsheet running the Userform at the same time as the UserForm is being displayed on screen, but is it possible to set a property on the UserForm/configure the Userform so that Excel can be completely minimised behind it? i.e so that when the 'workbook' is opened, only the Form itself, and not the Excel application, is visible on screen?
RE: UserForm Display
Hello Robert,
With regards to the Userform remaining open while excel minimised, this is a difficult area, and dependant on the windows version (some people have issues if using Win 2000 or XP!).
You could use a switch on the userform to min the application.windowstate = xlminimized
If you want the userform to remain on top of excel or any other windows you have open then you get into API code lines. Not enough space here to explain but some good examples on web. Try this one, it may point you in the right direction:
http://www.vbforums.com/showthread.php?t=588169
I hope this helps your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
