Posted to microsoft.public.excel.programming

Nigel RS[_2_] Nigel RS[_2_] is offline

external usenet poster

Posts: 80

Identifying Userform Control Type

Hi All
How can I identifiy the type of control (command button, testbox etc.) on a
userform?

I wish to do two things...

1. Store the control type in a sheet cell
2. Use a conditional depending on the control type

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
Identifying Control type	Graham Payne	Excel Programming	2	April 9th 06 09:15 AM
Identifying the type of a Worksheet_Change	Peter Rooney	Excel Programming	6	January 17th 06 02:38 PM
Userform Control Type	VBA Dabbler[_2_]	Excel Programming	4	June 10th 05 04:01 PM
Control Sequence from Userform Control	Nigel	Excel Programming	3	December 29th 04 01:25 PM
Identifying a Control Type	Chrissy[_4_]	Excel Programming	5	July 30th 03 08:25 AM

All times are GMT +1. The time now is 06:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us