User Form Option & Command Buttons
 

I have a user form with Opt. & Cmd. buttons, I am trying to get the
selected Optionbutton.caption to carry over to a sub. The same is true
of the cmdbuttons once one of them have been selected. This probably
seems to simple to answere but I've never done it before so any help
would be greatly appreiciated. Thanks in advance.


--
Information Hog
------------------------------------------------------------------------
Information Hog's Profile: http://www.excelforum.com/member.php...o&userid=21508
View this thread: http://www.excelforum.com/showthread...hreadid=397328

User Form Option & Command Buttons
 

Sub MyProcedure(optional byval strCaption as String)
'Procedure goes here
'Sample
Dim mVariable
mVariable = strCaption '<-- strCaption holds the caption string that
you pass on to this current procedure

End Sub

Ronin

"Information Hog" wrote:


I have a user form with Opt. & Cmd. buttons, I am trying to get the
selected Optionbutton.caption to carry over to a sub. The same is true
of the cmdbuttons once one of them have been selected. This probably
seems to simple to answere but I've never done it before so any help
would be greatly appreiciated. Thanks in advance.


--
Information Hog
------------------------------------------------------------------------
Information Hog's Profile: http://www.excelforum.com/member.php...o&userid=21508
View this thread: http://www.excelforum.com/showthread...hreadid=397328