UserForm Active

[grahammal]

I have generated a UserForm which I can call up from within my Excel spreadsheet OK.
How can I click on the cells in my spreadsheet while the UserForm is showing?
Its as if the UserForm has now become the active window which you can click on OK but have to hide it to resume working within the spreadsheet.
I need to be able to click on the commandbuttons in the UserForm and select cells in my spreadsheet with the UserForm showing.

[Toppers]

userform1.show vbmodeless

"grahammal" wrote:

>
> I have generated a UserForm which I can call up from within my Excel
> spreadsheet OK.
> How can I click on the cells in my spreadsheet while the UserForm is
> showing?
> Its as if the UserForm has now become the active window which you can
> click on OK but have to hide it to resume working within the
> spreadsheet.
> I need to be able to click on the commandbuttons in the UserForm and
> select cells in my spreadsheet with the UserForm showing.
>
>
> --
> grahammal
> ------------------------------------------------------------------------
> grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
> View this thread: http://www.excelforum.com/showthread...hreadid=508080
>
>

[grahammal]

I am trying UserForm4.Show vbModeless but it keeps coming up with a Compile Error. "Wrong number of arguments or invalid property assignment".

Sub StockPlan_Button68_Click()
UserForm4.Show vbModeless
End Sub

Any ideas

[Tom Ogilvy]

If you are using xl97, it doesn't have a vbModeless property. Otherwise it
should work.

--
Regards,
Tom Ogilvy


"grahammal" <[email protected]> wrote
in message news:[email protected]...
>
> I am trying UserForm4.Show vbModeless but it keeps coming up with a
> Compile Error. "Wrong number of arguments or invalid property
> assignment".
>
> Sub StockPlan_Button68_Click()
> UserForm4.Show vbModeless
> End Sub
>
> Any ideas
>
>
> --
> grahammal
> ------------------------------------------------------------------------
> grahammal's Profile:
http://www.excelforum.com/member.php...o&userid=20336
> View this thread: http://www.excelforum.com/showthread...hreadid=508080
>

[grahammal]

Thanx mate, am using Excel97.