Want to get user selections from a message box using option buttons

I have all kinds of books telling me how to create a userform. What I
need is the code to show the form with the option buttons and then
retrieve the info from it. I want the user to select which option he
wants and enter a date.

Any help would be greatly appreciated. I have been a programmer for
many years and understand many software languages. But Excel VB is a
killer. I know it can't be that hard.

Thanks

Walt,

You will usually get better answers if you provide the code that
you have already tried.

UserForm1.Show...will display the userform.

Dim strText as String
strText = UserForm1.TextBox1.Value...
places the contents of the textbox into the strText variable.

Jim Cone
San Francisco, USA


"Walt" <[email protected]>
wrote in message
news:[email protected]
I have all kinds of books telling me how to create a userform. What I
need is the code to show the form with the option buttons and then
retrieve the info from it. I want the user to select which option he
wants and enter a date.

Any help would be greatly appreciated. I have been a programmer for
many years and understand many software languages. But Excel VB is a
killer. I know it can't be that hard.

Thanks