LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 295
Default ActiveX controls still show data when empty

I have some ActiveX controls on a sheet - they have macros attached to them,
and they have a unique linked cell each.

When I clearcontents the linked cell the control (a ComboBox) still shows
the last lot of data that was in there. The only way I can get rid of it is
to select a blank line, and then delete the zero that it produces (rather
cumbersome and inelegant). Is there a setting I can change? Or a line of code
I can inset into the clearing macro? Regards, Brett
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
ActiveX Controls leerem Excel Discussion (Misc queries) 0 December 11th 08 01:11 PM
ActiveX Controls vs Form Controls Alex Excel Discussion (Misc queries) 1 January 11th 06 08:46 AM
How do I use ActiveX controls to hide/show rows on a sheet? activeXhelpPlease Excel Programming 2 October 27th 05 09:35 PM
activex controls Gary Excel Programming 2 May 15th 05 10:19 AM
ActiveX Controls David Fixemer Excel Programming 4 February 16th 04 05:20 PM


All times are GMT +1. The time now is 07:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"