Archive

Posts Tagged ‘user form’

Excel Vba Pivot Table

April 5th, 2009 Comments off

Hello
I need a user form in Excel which allows searching and selecting Pivot Items of Pivot Field in Pivot Table.

I posted this before. I have the macro that does almost all I need (one in excel 2003 and another in excel 2007), but have some problems that need to be solved and a little change in Excel 2007 version.
It has been developed with msflxgrd.ocx and msdatagrd.ocx controls, but windows update (KB960715) is causing me problems with those ocx.
If I uninstall that update, this works fine in xp but is not working in 2003 server (don

Excel Pivot Table Search/selec

March 20th, 2009 No comments

I need a user form in Excel which allows you to search and selection of items Pivot Field in Pivot Table.

I have Pivot TableS with pivot fields such as “book” or “customer” or “Invoice”. Each of these pivot field may have 20000 Pivot Item.

The User Form must:

deploy a combination of keys

allow searching in any of these fields (the user selects that pivot field will search)

the search must allow the use of wildcards (eg “book” contains “owne * manu).

display a list of all the pivot item containing “owne * manu”

Allow selection of 1 or more of the pivot item shown in the list

confirm selection

return to the Pivot Table by selecting the items marked on the user form and hiding the rest

Must work quickly, keep in mind that the pivot item may be several thousand.

It must work in Excel 2003 or 2007 .

The user must form a mark that achieves this selection to every pivot table of the active sheet or sheets of the active workbook.

The userform will be stored in a book in the XLStart folder.

I use Excel 2003 or 2007 with a Spanish version . I have to be able to adjust it to 2 or 3 different cases (minor changes to open source).

I will deliver a dynamic table in 2003 and another version in 2007 for testing verion.

Scrow payment

Bear