I have a workbook with some code inside of it. When I turn off Autofilter after using the buttons in the top left of the sheet to filter by cell color all of the text fields on the entire sheet are moving to A1 on top of each other. I have no idea why this is happening nor is it throwing an error. I uploaded the sheet here www.justinvalinski.com/newTest.xlsm for further review. I tried uploading on this site but the file is too large to upload. This one is just perplexing so any advice or if you know of a fix PLEASE let me know as I've been staring this one down for quite some time now.

I have a workbook with some code inside of it. When I turn off
Autofilter after using the buttons in the top left of the sheet to
filter by cell color all of the text fields on the entire sheet are
moving to A1 on top of each other. I have no idea why this is
happening nor is it throwing an error. I uploaded the sheet here
www.justinvalinski.com/newTest.xlsm for further review. I tried
uploading on this site but the file is too large to upload. This one
is just perplexing so any advice or if you know of a fix PLEASE let
me know as I've been staring this one down for quite some time now.

Yep, that's what happens when you use controls on a worksheet. I
stopped doing that long time ago. Instead of using controls I use
actual cells, and just make them look/feel/behave like controls so they
ALWAYS stay put (even if they're in scrollable/hidden sections of a
worksheet). I use the Worksheet_SelectionChange or Worksheet_Change
events, depending on the type of control being imitated, for executing
code.

--
Garry

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

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.

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.

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

There's one other possible resolve...

4. Use VBA to reposition controls that get moved from hiding/unhiding
areas of the worksheet where they are located. Of course this (and #2)
would be the most complex of solutions, #1 the easiest, and #3
somewhere in between!

Have fun...

--
Garry

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

Maybe next time you should download the workbook
before you give advice that is completely rediculous for the
situation.

Just for clarity.., I did look at your file before replying! It hurt my
eyes to look at it for any length of time but I see you do have the
controls positioned as in suggested solution #1. In this case I'll
spell it out for you...

Put AutoFilter *below* the controls, not at the top of the columns!

--
Garry

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

Suggestions 1,2,4 won't work for this particular issue. Although, #3 is a good idea and I'm already setting this up to go along with the right click command menu I've already coded :-) Also "Put AutoFilter *below* the controls, not at the top of the columns!" was the advice I needed from what I can gather from running multiple tests.

Thank you for the advice. I was a little short....it was Monday <-----HATE MONDAYS :-) Moving the sort below the objects seems to be working. If that advice came with a side of bacon you would be a super hero Garry. Thanks again!!!!!!!! :-)

Suggestions 1,2,4 won't work for this particular issue. Although, #3
is
a good idea and I'm already setting this up to go along with the
right
click command menu I've already coded :-)

If you modify the right-click menu you'll need to be careful to remove
your modifications at closing. Optionally, you can replace the
right-click menu with your own popup (custom commandbar). In this case
you'll also have to remove it on closing.

Also "Put AutoFilter *below*
the controls, not at the top of the columns!" was the advice I needed
from what I can gather from running multiple tests.

Thank you for the advice. I was a little short....it was Monday
<-----HATE MONDAYS :-) Moving the sort below the objects seems to be
working.

You're welcome! Glad I was able to "help"!<g

--
Garry

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