UserForm Active
 

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

--
grahamma
-----------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...fo&userid=2033
View this thread: http://www.excelforum.com/showthread.php?threadid=50808

UserForm Active
 

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

UserForm Active
 

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

Sub StockPlan_Button68_Click()
UserForm4.Show vbModeless
End Sub

Any idea

--
grahamma
-----------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...fo&userid=2033
View this thread: http://www.excelforum.com/showthread.php?threadid=50808

UserForm Active
 

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

--
Regards,
Tom Ogilvy


"grahammal" wrote
in message ...

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

UserForm Active
 

Thanx mate, am using Excel97

--
grahamma
-----------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...fo&userid=2033
View this thread: http://www.excelforum.com/showthread.php?threadid=50808