Posted to microsoft.public.excel.programming

Jon[_21_]

external usenet poster

Posts: 37

Creating a form with option buttons

I need to create a user form that has 4 option buttons and an ok button
to close the form. i have gotten the ok button to work fine with

Private Sub OK_Click()
Unload UserForm1
End Sub

but now i want to make the 4 option buttons set a variable to either
1,2,3, or 4. How can I do this? Do i need code in the private sub for
the button or in my main code? Thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
form option buttons - how can I make them accessible?	lynn	Excel Discussion (Misc queries)	1	February 10th 10 02:59 PM
Option Buttons in a Form	Idaho Word Man	Excel Discussion (Misc queries)	7	April 21st 08 09:58 PM
option buttons in a form	raw[_11_]	Excel Programming	0	November 11th 05 10:05 PM
User Form Option & Command Buttons	Information Hog[_2_]	Excel Programming	1	August 19th 05 10:00 PM
2 sets of option buttons on one user form?	Pal	Excel Programming	3	April 28th 04 02:45 PM

All times are GMT +1. The time now is 08:42 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us