Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform Listbox using an active sheet | Excel Discussion (Misc queries) | |||
userform - active sheet | Excel Programming | |||
Excel VBA: Move Userform Based on Active Cell? | Excel Programming | |||
Viewing a worksheet while a UserForm is active | Excel Programming | |||
Accessing a non-active sheet from a userform | Excel Programming |