Re: newbie: yes/no msgBox using a macro

Tech-Archive recommends: Speed Up your PC by fixing your registry

Another thing, when the focus is changed to the message box, I can't do
anything. I mean, I cannot change the focus using the mouse or something. I
have first to press enter (which activates the OK button in the message box,
I guess), and only then the macro continues running and I get back the
control of the focus.
--
dshemesh


"Ken Snell [MVP]" wrote:

> What is showing on the screen when you do this? Are you using an expression
> in a Condition column to display the message box? More details, please.
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "dshemesh" <dshemesh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:38611CBF-18A1-439C-A683-58425C241FCC@xxxxxxxxxxxxxxxx
> > thank you.
> > I have another problem - whenever I put a msgbox using a macro it doesn't
> > appear on screen. It's as if the message box is shown somewhere on the
> > background, and awaits the user to press a button, but it can't actually
> > be
> > seen.
> > any ideas?
> > thanks
> > --
> > dshemesh
> >
> >
> > "Ken Snell [MVP]" wrote:
> >
> >> Macros don't recognize vbYes and vbNo, so you use the actual numbers for
> >> them. Otherwise, you use the same expression to test the user's answer,
> >> and
> >> put the expression in the Condition column of the macro (32 is the value
> >> of
> >> vbQuestion, 4 is the value of vbYesNo, 7 is the value of vbNo, 6 is the
> >> value of vbYes, 0 is the value of vbDefaultButton1, 256 is the value of
> >> vbDefaultButton2, and so on):
> >>
> >> 7=MsgBox("Do you want to continue?", 32+4+256, "Continue?")
> >>
> >>
> >> --
> >>
> >> Ken Snell
> >> <MS ACCESS MVP>
> >>
> >> "dshemesh" <dshemesh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:EAD7F1D2-EEB6-4505-97FA-A26D8F2FBF05@xxxxxxxxxxxxxxxx
> >> > hello,
> >> > I want a macro that as a first action askes the user if he's sure he
> >> > wants
> >> > to proceed, and proceeds only if the user answers yes. I'm used to
> >> > doing
> >> > these kind of actions using visual basic, with a vbyesno msgbox, but I
> >> > can't
> >> > find a way doing it through a macro...
> >> > thanks
> >> > --
> >> > dshemesh
> >>
> >>
> >>
>
>
>
.

Quantcast