Posted to microsoft.public.excel.programming

MWE[_38_]

external usenet poster

Posts: 1

Array of OptionButtons ?

Tom Ogilvy wrote:
[b]Dim obtn as MSForms.OptionButton
for each ctrl in userform1.controls
if typeof ctrl is MSForms.OptionButton then
set obtn = ctrl
msgbox obtn.Name
end if
Next
--
Regards,
Tom Ogilvy

Tom: thanks, this works.

MW

--
Message posted from http://www.ExcelForum.com

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
UserForm OptionButtons	Horatio J. Bilge, Jr.	Excel Discussion (Misc queries)	3	October 4th 07 07:52 PM
Moving OptionButtons	MarkyB	Excel Discussion (Misc queries)	2	March 7th 06 02:50 PM
OptionButtons	Paul	Excel Programming	4	December 4th 03 04:12 PM
Add OptionButtons in Excel	Andrew Lenczycki	Excel Programming	0	July 30th 03 02:34 PM
optionbuttons	Phil Perry	Excel Programming	1	July 10th 03 09:13 PM

All times are GMT +1. The time now is 01:45 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us