Hello,

I have a VB6 ActiveX Exe that displays a form. The form is called from a VBA
macro in Excel.

The problem I have is when the form is activated Excel lost focus
(obviously) but also the range the user has selected in a worksheet
disappears.

This is a problem and confusing for the user (did I select correct cells or
not?) since the user doesn't see the selection anymore when the VB6 form is
activated.

I've tried almost everything but can't get it to work.

Any suggestion will be appreciated.

Thanks in advance.

/Nicke