PC Review


Reply
Thread Tools Rate Thread

Add to Combo Control from referenced worksheet object

 
 
Matt
Guest
Posts: n/a
 
      8th Apr 2008
I have a workbook that contains a worksheet named "Sheet1"
on that worksheet I have a combo box (type: control toolbar) . I have
a little procedure that adds values to the combo box. When
I refer to the combo box as
thisworkbook.worksheets("Sheet1").combobox1.AddItem i
or for that matter wkb.worksheets("Sheet1").comboBox1.Additem i
it works fine. However when I create a reference to a worksheet object
in thisworkbook
Such as:
set wkb = thisworkbook
set wks = wkb.worksheets("Sheet1")
wks.ComboBox1.AddItem i
and add an item, I get an error message. Does anyone know why that is?
Thanks,
Matt
 
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
can every object be serialized even with referenced object within in a complex scenario Tony Johansson Microsoft C# .NET 2 5th Mar 2010 04:27 PM
Fw: Referenced COM Object Versus Dynamic Load Of COM Object Claire Microsoft C# .NET 2 9th Oct 2008 03:17 AM
How to Place a Drawing Object on a Worksheet as a Control? SteveM Microsoft Excel Programming 6 21st Jan 2008 01:19 PM
Combo Boxes built with Control Toolbox on a Worksheet =?Utf-8?B?QWxhbg==?= Microsoft Excel Programming 1 11th Aug 2005 11:28 AM
Setting Combo box Range for Worksheet Control Limits Microsoft Excel Programming 3 23rd Mar 2004 04:50 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:36 PM.