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

W

Walt

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
 
J

Jim Cone

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
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
 
Top