| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active Form
Hi,
I am just starting to design a form and can upload it using the "formname.show". This works fine but I would like the user to be able to move around the spreadsheet at the same time entering values into the form (e.g. they can switch between the two). Please can someone explain the kind of code I need ? Many Thanks in advance Pete |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Active Form
A user form has a modal property that is set as an argument of the show
method... So all you need is formname.show False The default value is true if it is not specified... -- HTH... Jim Thomlinson "Pete" wrote: Hi, I am just starting to design a form and can upload it using the "formname.show". This works fine but I would like the user to be able to move around the spreadsheet at the same time entering values into the form (e.g. they can switch between the two). Please can someone explain the kind of code I need ? Many Thanks in advance Pete |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Active Form
formname.show 0
-- HTH Bob Phillips "Pete" wrote in message ... Hi, I am just starting to design a form and can upload it using the "formname.show". This works fine but I would like the user to be able to move around the spreadsheet at the same time entering values into the form (e.g. they can switch between the two). Please can someone explain the kind of code I need ? Many Thanks in advance Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Active X Controls Tabbing from Form Field 2 Form Field | Excel Discussion (Misc queries) | |||
| Form Button not active | Excel Discussion (Misc queries) | |||
| Active Form during Execution | Excel Discussion (Misc queries) | |||
| Active user form | Excel Programming | |||
| Can I set a page of a Multipage form to active? | Excel Programming | |||
Hybrid Mode
