View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Modeless Msgbox?

Re-read my response PJ, and try it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"PJohnson" wrote in message
news:MHWFd.23510$sf5.14250@lakeread05...
An inputbox is modal also. I just need to user to be able to perhaps

select
or copy or paste something (on the excel sheet itself) before continuing
with the code.


"Bob Phillips" wrote in message
...
Depends on what you want to be able to do, but look at

Application.Inputbox
in VBA Help.

--
HTH

Bob Phillips

"PJohnson" wrote in message
news:FnWFd.23509$sf5.8788@lakeread05...
Is there anyway to display/show a modeless msgbox (vbOKOnly)? I need

the
user to be able to do something before continuing. I guess I am trying

to
avoid a userform. Any help appreciated.

Pete