PC Review


Reply
Thread Tools Rate Thread

Adding checkbox to worksheet in C#

 
 
=?Utf-8?B?QWJoaW1hbnl1IFNpcm9oaQ==?=
Guest
Posts: n/a
 
      13th Mar 2007
I am using Excel object model in C# using Office XP PIA.
I want to add a checkbox to the worksheet programmatically. In VBA I can add
a checkbox using the 'CheckBoxes' collection's Add method but there is no
such collection in PIA classes.

regards

 
Reply With Quote
 
 
 
 
NickHK
Guest
Posts: n/a
 
      13th Mar 2007
From the macro recorder::

ActiveSheet.OLEObjects.Add(ClassType:="Forms.CheckBox.1", Link:=False, _
DisplayAsIcon:=False, Left:=642.75, Top:=159.75, Width:=103.5,
Height _
:=21.75).Select

NickHK

"Abhimanyu Sirohi" <(E-Mail Removed)> wrote in
message news:A05A423C-7433-4D68-9C55-(E-Mail Removed)...
> I am using Excel object model in C# using Office XP PIA.
> I want to add a checkbox to the worksheet programmatically. In VBA I can

add
> a checkbox using the 'CheckBoxes' collection's Add method but there is no
> such collection in PIA classes.
>
> regards
>



 
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
Checkbox to open another worksheet =?Utf-8?B?U0xLb2Vsa2Vy?= Microsoft Excel Misc 3 21st Aug 2007 05:56 PM
checkbox and worksheet =?Utf-8?B?SmVubg==?= Microsoft Excel Misc 2 26th Jun 2006 04:38 PM
CheckBox value to worksheet Patrick Simonds Microsoft Excel Programming 2 14th Jun 2004 05:54 PM
Loop through checkBox on worksheet bman Microsoft Excel Programming 3 26th Nov 2003 03:22 PM
Re: accessing CheckBox on Worksheet Mike Tomasura Microsoft Excel Programming 4 24th Jul 2003 01:19 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:29 AM.