Excel Macro - UserForm Control

[ranouilh]

I have a UserForm that is all ways showing in my spreadsheet and I use it run several macros that manipulate data in the sheets. After running one of the macros I would like to make the sheet active but the UserForm stays active causing me to have to click my mouse on the sheet to activate the sheet. Is there a way in the VBA code of my macro to activate the sheet but keep the UserForm visible? This way when the macro completes I will not have to click my mouse on the cell I can just start typing in data.

 

[XLGibbs]

In the properties of the Form in VB editor you can change the display to vbModeless (it is probably set to vbModal).

The actual syntax may be slightly different, but a modeless Form display keeps the Form visible and allows sheet interaction

Maybe?

 

[ranouilh]

It is already set at follows:
UserForm1.Show vbModeless

 

[Legacy 98055]

Not sure if you can without using an API function. Place this in your userform in the general declarations section..

Private Declare Function SetFocus Lib "user32" (ByVal hwnd As Long) As Long

Call it at the end of your macro as such...

SetFocus Application.hwnd

Depending on the version of your Office software, "Application.hwnd" may not be available. If not, post back and we'll work around it with another function or two.

Tom

 

[ranouilh]

Right_Click

Thanks for the quick reply! This worked exactly as I needed.