PC Review


Reply
Thread Tools Rate Thread

change properties on

 
 
=?Utf-8?B?azJzYXJhaA==?=
Guest
Posts: n/a
 
      1st Nov 2006
i am trying to modify the property of control toolbox by looping through all
the controls on a spreadsheet. below is the code. in the code below i am able
to retrieve properties such as (xa=ctl.name), but am unable to alter the
properties of the control. CTL.Caption="test" returns an error. any help
would be appreciated.

thks


Dim ctl as Object
For each ctl in ActiveSheet.Shapes
xa=ctl.Name
ctl.caption="test"?
Next

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change PDF properties Seanie Microsoft Excel Programming 2 9th Feb 2009 07:04 PM
cannot change the TCP/IP properties nvaderx Windows XP Networking 5 11th Jul 2006 10:50 AM
Properties change in VBA =?Utf-8?B?S29sb3M=?= Microsoft Access Queries 4 25th Sep 2005 08:41 AM
VBA Change Doc Properties John Microsoft Powerpoint 2 10th Feb 2005 02:00 PM
HELP: Properties won't change =?Utf-8?B?QVVUaWdlcjk3?= Windows XP Help 2 28th Jan 2005 12:11 AM


Features
 

Advertising
 

Newsgroups
 


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