View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default MsgBox Replacement w/ an UserForm

Optionbuttons are one way.

Let's see the code if you want further help.

--

HTH

RP

"Chuckles123" wrote in message
...

Tom, Thanks.
I am making progress. My UserForm works, except that my IF..THEN..ELSE
is defaulting to ELSE regardless of which button is selected by User. I
stepped-through the macros line-by-line and the appropriate UserForm
procedures are being accessed based upon user selection; however,
everything after 'Then' and before 'Else' is being ignored by the
macro.

Help.
Chuckles123

P.S.: I am assuming that Option Buttons can also be utilized for this
application.


--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile:

http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=267872