Where can I find DataGridView for VBA? DataGridView vs DataGri

Where can I find DataGridView for VBA? DataGridView vs DataGri

Post by QXZp » Wed, 10 Jan 2007 08:06:00


gt;> There is no "DataGridView" control for VBA. This is a Visual Studio
"thingy",
~~ Well that pretty much wraps that up then, doesn't it? ('scuse the pun...)

Then again, I suppose if I really want to use the DataGridControl that much,
I could write my Word control app in VB, and use it to control Word "from the
outside". But would I be also able to follow VBA code execution within the
Word VBA IDE?

Thanks, Cindy.

- avi


"Cindy M." wrote:

 
 
 

Where can I find DataGridView for VBA? DataGridView vs DataGri

Post by QXZp » Wed, 10 Jan 2007 08:17:01

gt; I would use textboxes and a listbox with Add, Edit and Delete Command
<ETC>
<SNIP>

WOW...
And you don't even suggest using Data Grid? Why not? Too complex? Too buggy?
So I understand you don't like the various "Grid"s? All I wanted was a simple
reliable table to put onto a VBA form, that the user could type data into
directly. Was that too much to ask from the Microsoft team? Apparently yes,
it seems...

Sounds like that cartoon strip of the product requirements specifying a
simple child's play swing , and then the design and implementation get more
and more enhanced until the project crashes and the super-sophisticated
three-seat, motor-driven swing falls off it's ropes and dies.

tnx

- avi




"Doug Robbins - Word MVP" wrote:


 
 
 

Where can I find DataGridView for VBA? DataGridView vs DataGri

Post by Doug Robbi » Wed, 10 Jan 2007 13:36:22

he people who provide assistance in these newsgroups do NOT work for
Microsoft.

I have never used the DataGridView. I don't even know what it is as I have
never come across it as an option when designing userforms, of which I have
designed many.

Maybe I should not have responded to your post, but I did so as the
information I provided was one way in which the user has a degree of control
over the data that they are entering.

However, it doesn't matter what you use, if the user inserts the wrong
information.....

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Avi" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...


 
 
 

Where can I find DataGridView for VBA? DataGridView vs DataGri

Post by QXZp » Wed, 10 Jan 2007 18:16:01

gt;> The people who provide assistance in these newsgroups do NOT work for
Microsoft.

Yes, that is perfectly understood. I was aiming my comment at the heavens,
not at you.

Thanks,

- avi


"Doug Robbins - Word MVP" wrote:

 
 
 

Where can I find DataGridView for VBA? DataGridView vs DataGri

Post by Cindy M » Thu, 11 Jan 2007 00:17:06

Hi =?Utf-8?B?QXZp?=,

Often, it is possible to use VB (classic, not .NET) controls directly on Office
UserForms. Licensing and distribution could certainly be an issue. And sometimes
they don't work too well - thorough testing is required. I haven't tried the
controls you mention, myself, so that's all just theory :-) If you post a
separate question, asking if anyone has experience with the classic VB controls
on Office UserForms you might get some useful input. I'd also try asking in the
excel.programming newsgroup as those folks have very broad experience in this
field.

As to your question: can you be more precise about what you mean by "follow VBA
code execution with the Word VBA IDE"? What do you have in mind, here?

Cindy Meister
INTER-Solutions, Switzerland
http://www.yqcomputer.com/ (last update Jun 17 2005)
http://www.yqcomputer.com/

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)
 
 
 

Where can I find DataGridView for VBA? DataGridView vs DataGri

Post by Helmut Web » Thu, 11 Jan 2007 01:00:34

Hi Cindy, hi Avi,

some years ago, because then ignorant of datagrid or MSflexgrid
and others of the like, I put up forms looking like datagrid,
using listboxes, put the listboxes into an array,
possible at runtime,
synchronized the listboxes,
so that scrolling in one would scroll the others, too,
so that selecting item(x) would select item(x) in the others, too,
if wanted,
and dare say, I still feel comfortable with it.

Once done, such an approach is much more flexible
than a prefabricated datagrid.

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"