Why not use a MsgBox instead.

Dim x
x = MsgBox("Do you want to see the form?", vbYesNoCancel)

If x = vbYes then

elseif x = vbNo then

elseif x = vbCancel then

else

end if
--
steveB

Remove "AYN" from email to respond
"blacktour" wrote
in message ...

I have posted this on 2 other excel forums and I am yet to get an
answer. Maybe someone here can help.

Combox with YES and NO
if Yes selected I want a userform to appear with three text boxes that
are totalled
if you use the mouse it works fine
if you use the keyboard and type "y" the userform appears but doesn't
add the 3 text boxes in it??

Check out 'Another Forum'
(http://www.ozgrid.com/forum/showthread.php?t=36774) for the example
spreadsheet posted.

Thanks,
Mike


--
blacktour
------------------------------------------------------------------------
blacktour's Profile:
http://www.excelforum.com/member.php...o&userid=25368
View this thread: http://www.excelforum.com/showthread...hreadid=388693