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