| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX controls still show data when empty
THIS POST IS NO LONGER REQUIRED. Thanks to all.
"Brettjg" wrote: Hi Dave I have a suspicion that dropping the linked cell will cause too much re-coding, but if JLGWhiz comes up with something later it may help. "Dave Peterson" wrote: You may want to drop the linked cell. They can cause other trouble, too. I think I'd just use code to update the cell (combobox1_change??). Brettjg wrote: 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 -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ActiveX Controls | Excel Discussion (Misc queries) | |||
| ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
| How do I use ActiveX controls to hide/show rows on a sheet? | Excel Programming | |||
| activex controls | Excel Programming | |||
| ActiveX Controls | Excel Programming | |||
Threaded Mode
