Hi there,

Can anyone point me towards a gridview style control that I can use in a
form (vba)?

Thanks

John

Hi John

Will the Microsoft Office Spreadsheet control do ?

HTH. Best wishes Harald

"John" skrev i melding
...
Hi there,

Can anyone point me towards a gridview style control that I can use in a
form (vba)?

Thanks

John

Hi Harald,

Thanks for your reply. I've had a quick look and at first glance it appears
to offer too much control to the user.

Is there anything more simple?

Thanks again

John
"Harald Staff" wrote in message
...
Hi John

Will the Microsoft Office Spreadsheet control do ?

HTH. Best wishes Harald

"John" skrev i melding
...
Hi there,

Can anyone point me towards a gridview style control that I can use in a
form (vba)?

Thanks

John

Hi again John

The use of "external components" is also known as "dll hell", referring to
the joy of installation, licensing, versions and all other interesting
phenomena. So while another grid may be easier for you to program, it may be
close to impossible and/or very expensive to deploy. So yes, the world is
full of datagrids, few if any are free, and few users are allowed to install
them.

When I want a pure data viewer, I put a picture of a hidden formatted
worksheet onto a dialogsheet (which is not a userform) or directly onto a
spreadsheet. That is as good looking as the decorated sheet, and not
interactive at all unless I provide extra scrollbars, entryboxes, ... I can
email you a demo of that if you post some kind of valid address here.

Another idea is to put the spreadsheet in mention onto a Frame control and
set the frame's Enabled property to False. You must then do some scrollbar
programming in addition I guess.

HTH. best wishes Harald

"John" skrev i melding
...
Hi Harald,

Thanks for your reply. I've had a quick look and at first glance it
appears to offer too much control to the user.

Is there anything more simple?

Thanks again

John
"Harald Staff" wrote in message
...
Hi John

Will the Microsoft Office Spreadsheet control do ?

HTH. Best wishes Harald

"John" skrev i melding
...
Hi there,

Can anyone point me towards a gridview style control that I can use in a
form (vba)?

Thanks

John

Hmm. Ok, I get the message. Maybe I'll head back to your original
suggestion then!

Thanks for your time Harald.

Best regards

John
"Harald Staff" wrote in message
...
Hi again John

The use of "external components" is also known as "dll hell", referring to
the joy of installation, licensing, versions and all other interesting
phenomena. So while another grid may be easier for you to program, it may
be close to impossible and/or very expensive to deploy. So yes, the world
is full of datagrids, few if any are free, and few users are allowed to
install them.

When I want a pure data viewer, I put a picture of a hidden formatted
worksheet onto a dialogsheet (which is not a userform) or directly onto a
spreadsheet. That is as good looking as the decorated sheet, and not
interactive at all unless I provide extra scrollbars, entryboxes, ... I
can email you a demo of that if you post some kind of valid address here.

Another idea is to put the spreadsheet in mention onto a Frame control and
set the frame's Enabled property to False. You must then do some scrollbar
programming in addition I guess.

HTH. best wishes Harald

"John" skrev i melding
...
Hi Harald,

Thanks for your reply. I've had a quick look and at first glance it
appears to offer too much control to the user.

Is there anything more simple?

Thanks again

John
"Harald Staff" wrote in message
...
Hi John

Will the Microsoft Office Spreadsheet control do ?

HTH. Best wishes Harald

"John" skrev i melding
...
Hi there,

Can anyone point me towards a gridview style control that I can use in
a form (vba)?

Thanks

John

No problem & good luck. If you work on something big and/or important,
please get a second opinion somewhere before deciding.

Best wishes Harald

"John" skrev i melding
...
Hmm. Ok, I get the message. Maybe I'll head back to your original
suggestion then!

Thanks for your time Harald.