Text boxes moving to Cell A1 on top of each other after turning off AutoFilter

[ndjustin20]

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

 

[GS]

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

 

[ndjustin20]

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

;1610773']> I have a workbook with some code inside of it. When I tur
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 the

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.discussio

 

[GS]

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

 

[GS]

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

 

[GS]

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

 

[ndjustin20]

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

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

;1610856']> 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 m

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.discussio

 

[GS]

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