Prev: How to automatically trigger the vba coding by opening worksheet?
Next: UserForm will not appear
From: Trev B on 11 Feb 2010 13:08
Hi,

Thanks in advance

During vba I open a msgbox which shows user the answers to be updated in
another workbook. The user must check these answers on the current worksheet
before the user agrees to the update.

My problem is that the user can't scroll up & down the worksheet until the
question is answer.

How do I help them look at the rest of the sheet and not just what is shown
when the code started?

Thanks

Trev B
From: Dave Peterson on 11 Feb 2010 15:12
Replace the msgbox with a userform.
Then show the userform modelessly.

Option Explicit
Sub ShowTheForm()
Userform1.show vbmodeless
End sub





Trev B wrote:
>
> Hi,
>
> Thanks in advance
>
> During vba I open a msgbox which shows user the answers to be updated in
> another workbook. The user must check these answers on the current worksheet
> before the user agrees to the update.
>
> My problem is that the user can't scroll up & down the worksheet until the
> question is answer.
>
> How do I help them look at the rest of the sheet and not just what is shown
> when the code started?
>
> Thanks
>
> Trev B

--

Dave Peterson
From: Trev B on 13 Feb 2010 08:11
Thanks works a dream
--
Trev B


"Dave Peterson" wrote:

> Replace the msgbox with a userform.
> Then show the userform modelessly.
>
> Option Explicit
> Sub ShowTheForm()
> Userform1.show vbmodeless
> End sub
>
>
>
>
>
> Trev B wrote:
> >
> > Hi,
> >
> > Thanks in advance
> >
> > During vba I open a msgbox which shows user the answers to be updated in
> > another workbook. The user must check these answers on the current worksheet
> > before the user agrees to the update.
> >
> > My problem is that the user can't scroll up & down the worksheet until the
> > question is answer.
> >
> > How do I help them look at the rest of the sheet and not just what is shown
> > when the code started?
> >
> > Thanks
> >
> > Trev B
>
> --
>
> Dave Peterson
> .
>
 | 
Pages: 1
Prev: How to automatically trigger the vba coding by opening worksheet?
Next: UserForm will not appear