Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Walt
 
Posts: n/a
Default 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

  #2   Report Post  
Jim Cone
 
Posts: n/a
Default Want to get user selections from a message box using option buttons

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"
wrote in message
ps.com
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Check box and and formula Russell-stanely Excel Discussion (Misc queries) 7 July 7th 05 10:06 PM
conditional option button help tjb Excel Worksheet Functions 1 March 2nd 05 12:19 AM
How do I input a warning message to remind the user to enter into. sugarbrit17 Excel Discussion (Misc queries) 3 January 25th 05 09:31 PM
conditional error for option button tjb Excel Worksheet Functions 3 December 30th 04 12:26 AM
File is locked for Editing by user problem Mirth Excel Discussion (Misc queries) 1 December 3rd 04 05:45 PM


All times are GMT +1. The time now is 05:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"