Modeless UserForm

[Sri]

Hi,

I want to create a Modeless userform which allows users to
use the excel sheets and the userform simultaneously.

It is something like the bar which comes with the Excel
functions wizard. When you click the small icon on the
right side, it allows you to select a cell(s) on the sheet.

I want to do something like that by enabling users to use
the sheet simultaneously.
Any help would be appreciated.

Rgds
Sri

 

[Chip Pearson]

This is possible only in Excel 2000 and later. To show the form
modelessly, use the vbModeless argument to the Show method. E.g.,

Userform1.Show vbModeless

To enable selecting cells on the worksheet and put the results on
the form, use the RefEdit control.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com