Posted to microsoft.public.excel.programming

VBA Dabbler[_2_] VBA Dabbler[_2_] is offline

external usenet poster

Posts: 54

Userform Control Type

I'm trying to step through a collection of controls on a userform and, based
on type, take certain steps.

Does anyone know the syntax for determining a userform control's 'type'?
For example: is Control(i) a Textbox, Checkbox, Combobox, etc.

Thanks,
VBA Dabbler

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
Control Sequence from Userform Control	Nigel	Excel Programming	3	December 29th 04 01:25 PM
Type of textbox on userform	Lieven Mettepenningen[_2_]	Excel Programming	2	October 15th 03 01:36 PM
Identifying a Control Type	Chrissy[_4_]	Excel Programming	5	July 30th 03 08:25 AM
UserForm Control	John Wilson	Excel Programming	0	July 16th 03 06:53 PM
UserForm Control	Richard Choate	Excel Programming	0	July 16th 03 06:50 PM

All times are GMT +1. The time now is 12:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us