Worksheet Control in Userform

**herghost** · 07-04-2012, 08:28 AM

Hi Guys

I have an worksheet embedded into a Userform which outputs some information from a database.

What I am trying to do is add some autofilters in VBA.

Basically I am stuck fast, nothing I have used before works, I guess this is because the worksheet control is somehow different from an actual worksheet?

Even trying to select a range for the autofilter results in an 'The range you are trying to select is not completely in the viewable range' error.

Has anyone figured out how to do this in a worksheet control? This is what I am trying:

Please Login or Register  to view this content.

Cheers

**JBeaucaire** · 07-04-2012, 10:35 AM

You need to edit out all the "selecting" in your macros. Recorded macros show this syntax because it's recording your human actions, but it's not the right way to do it in the end.

So, send your commands directly to the fully addressed objects, no selecting:

Please Login or Register  to view this content.

Now that the selecting is removed, those commands can work because you're not trying to show anything onscreen, it's just "doing it" on the other sheet while out of view. Much more efficient.

**royUK** · 07-04-2012, 01:51 PM

Spreadsheet Controls are no longer available from Excel 2007 & were never well supported. I haven't got the control on my PC now but you need to use the Object Browser to check out the way it is used. To be honest it's not worth the effort, I would use a listBox.