Special Control Needed - Please Advise
 

I have need for a UserForm control with multiple columns with headers. I'd
like the headers to be clickable and adjustable in width on the fly. I
thought about using a multi-column ListView (and this could work in a pinch),
but I wasn't getting the flexibility of it that I wanted.

Are there any other controls available to us that allow for multiple columns
with headers? I know I've seen these before, but I couldn't come up with a
specific example while writing this. Thanks!

Pflugs

Special Control Needed - Please Advise
 

There is a "spreadsheet" control that looks like, um, a spreadsheet.
You should be able to add it to the tool box using "additional controls".
Find that by right-clicking the tool box. The one you want is...
"Microsoft Office Spreadsheet xx.0"
A nice feature, is that it comes with its own help. Click the "?" at the top right
after it is added to the userform.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Pflugs"
wrote in message
I have need for a UserForm control with multiple columns with headers. I'd
like the headers to be clickable and adjustable in width on the fly. I
thought about using a multi-column ListView (and this could work in a pinch),
but I wasn't getting the flexibility of it that I wanted.

Are there any other controls available to us that allow for multiple columns
with headers? I know I've seen these before, but I couldn't come up with a
specific example while writing this. Thanks!

Pflugs

Special Control Needed - Please Advise
 

That's a great find, and that might work perfectly. Do you know of any
others? I don't necessarily need the full functionality of a spreadsheet.

Thanks!
Pflugs

"Jim Cone" wrote:


There is a "spreadsheet" control that looks like, um, a spreadsheet.
You should be able to add it to the tool box using "additional controls".
Find that by right-clicking the tool box. The one you want is...
"Microsoft Office Spreadsheet xx.0"
A nice feature, is that it comes with its own help. Click the "?" at the top right
after it is added to the userform.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Pflugs"
wrote in message
I have need for a UserForm control with multiple columns with headers. I'd
like the headers to be clickable and adjustable in width on the fly. I
thought about using a multi-column ListView (and this could work in a pinch),
but I wasn't getting the flexibility of it that I wanted.

Are there any other controls available to us that allow for multiple columns
with headers? I know I've seen these before, but I couldn't come up with a
specific example while writing this. Thanks!

Pflugs

Special Control Needed - Please Advise
 

I think I found what I was looking for. The spreadsheet control was just too
advanced for what I wanted it to be, so I experimented around. I finally
found and settled on the MSFLexGrid control.

I was able to set up column headers, remove row headers, import text from my
test sheet, and even write events to sort the data based on which column was
double-clicked. After I am satisfied with the code, I will post it here for
others to look at.

Thanks, Jim, for your help tonight.
Pflugs

"Pflugs" wrote:

I have need for a UserForm control with multiple columns with headers. I'd
like the headers to be clickable and adjustable in width on the fly. I
thought about using a multi-column ListView (and this could work in a pinch),
but I wasn't getting the flexibility of it that I wanted.

Are there any other controls available to us that allow for multiple columns
with headers? I know I've seen these before, but I couldn't come up with a
specific example while writing this. Thanks!

Pflugs