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.
Last edited by Information Hog; 08-22-2005 at 01:16 PM.
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
>
>
Still not sure how this works, a little more explaination is required for myself to understand how this works or maybe you or someone knows of a web site I could look at. The problem is I can't get which OptionButton was selected/I can't get the selection choice back to the variable in the calling sub, it still comes up empty. Sorry and thanks for the reply.
Last edited by Information Hog; 08-22-2005 at 01:23 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks