View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Text boxes moving to Cell A1 on top of each other after turning off AutoFilter

Thanks for the "help" Garry. I'm not sure how using ActiveX controls
on
anything microsoft with VBA has anything to do with the issue I am
having. And how exactly would using a cell help in this
instance?!?!??!? Maybe next time you should download the workbook
before you give advice that is completely rediculous for the
situation.
Good luck though Garry. I'm sure someone out there needs a good
solid
lesson on making ice


I'm going to ignore your smart-ass remarks!

Using AutoFilter is the issue. The controls get shoved off position and
so you end up with them stacked/bunched together somewhere at the top
of the sheet.

Possible solutions:

1. Use FreezePanes and put controls above the scrollable area.

2. Don't use controls in scrollable areas! Instead, use Styles to
make cells look/act/feel like controls and manage them with
Worksheet events.

3. Use a custom toolbar!

Good luck...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion