Hi,
I am a bit confused with this one.
I threw together a quick homemade pivot table for this project which uses a listbox and some combo headers to control the rowsource.
(theres probably an easier way/control to use - feel free to recommend (prefer an unbound solution))
Anyway, there are combo boxes aligned,sized, and spaced above the listbox to change the field of interest.
Its probably best at this point to look at the images attached to understand my issue:
Notice the comboboxes don't align with the columns in the listbox.
The positioning + widths are all controlled via code at runtime.
The fact that they don't align makes no sense here: the listbox columns are set to 1". The comboboxes are set to 1" widths and they are all aligned left of eachother.
Yet there is an error occurring somewhere in the alignment to the listbox and I'm out of thoughts.
See attached!
Any ideas?
Regards