Posted to microsoft.public.excel.programming

-JEFF-[_2_] -JEFF-[_2_] is offline

external usenet poster

Posts: 26

Are all properties of controls on ctrl toolbox toolbar accessable?

Using the OptionButton from the controls toolbox toolbar, I am unable to
access the linkedcell property using the following code. I have accessed
some of the properties, (caption, value) using this syntax but when I try to
change LinkedCell, I get "object doesn't support this property or method"
How do I change the linkedcell property?

ActiveSheet.OLEObjects("OptionButton" & iob).Object.LinkedCell = "P11"

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
Controls Toolbox	Gene Augustin	Excel Discussion (Misc queries)	0	October 10th 09 03:40 PM
Control Toolbox Controls	spIky haIred	Excel Programming	0	August 24th 05 08:13 AM
VBA excel formatting properties not accessable	dp	Excel Programming	0	May 18th 05 05:49 PM
Controls Toolbox control vs Form Toolbox control	Tony_VBACoder	Excel Programming	3	January 28th 05 08:30 AM
Additional toolBox controls	Soniya[_2_]	Excel Programming	1	January 10th 04 06:40 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us