Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » UserForm Display

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

UserForm Display

Resolved · Low Priority · Version 2003

Reply Mon 16 Jan 2012, 09:42 Edited on Mon 16 Jan 2012, 09:43Delegate Robert said...

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?

For upcoming training course dates see: Pricing & availability

Reply Fri 20 Jan 2012, 09:39Trainer Mark said...

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

Reply Fri 20 Jan 2012, 09:46Delegate Robert said...

RE: UserForm Display

Thanks Mark

Excel articles

· Simple Ways To Customise Excel
· How To Make Excel Open A Particular File When It Launches
· Create A Basic Timeline In Excel
· Tips From Excel's 'Rarely Used' File
· Some Interesting Finds In Excel 2007/2010 Using Find And Select

Please browse our web site to find out more about
excel+vba+training and other Microsoft training courses.

Excel tip:

Customize the toolbar in Excel 2010

You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please.

View all Excel hints and tips