Keep userform on top

Hi

I have written a VBA code in AutoCAD to export information to excel,

Is there a way I can keep userforms on top of all application windows (i.e Always show)

Hope someone can help

Streng

I am thinking that Windows API is the way forward - Any Suggestions ?

Thanks but still having trouble that the userform is still attached to AutoCAD, when I click on the userform it brings CAD to the top.
Will have to rethink my code.

Thanks Leith, this is the first code that I have been able to get to work for me (64 bit machine).
I had to modify it as follows:
Replace the 2 lines beginning "Const..." with the following lines:

Please Login or Register  to view this content.

I have found a way to make my forms come to the top when I load them, and still behave “normally”. I have tried to do this a number of times in the past with different API functions, but always had negative/mixed results. This works well for me but it may or may not work for you – you will have to test it and see:


(1) At the top of a normal module (I think a form module is OK too):

Please Login or Register  to view this content.

I think Private can be changed to Public if it is to be called from different modules.


(2) I use Form1.Show but you may use a different command to display your form. Then to make it on top:

Please Login or Register  to view this content.

(3) Dimension the handle as public

Please Login or Register  to view this content.

(4) To get the handle, I use this code in the Initialize sub for the Form1 module:

Please Login or Register  to view this content.

Only minor but, I have never been able to SetFocus to the form so as to highlight it. If anyone has worked out how to do that …..