Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Add a grid control to a vba form

19 views
Skip to first unread message

docsis

unread,
Jul 4, 2010, 9:58:05 PM7/4/10
to
My goal is to add a data entry tool to the Payment Application Screen. So far
I added a new vba form and now I would like to add a grid control to it.
There is alot of documentation on doing this with a VB Tools screen but not
with a standard SL screen using vba. Can someone point me in the right
direction?

Barry Flynn

unread,
Jul 5, 2010, 4:38:36 AM7/5/10
to
To my knowledge, you can't add a "Solomon grid" to a VBA form.
As far as I know, you can add a "standard VB Grid", but you will have to
write all the "plumbing" so that when a document is loaded, it displays the
correct information etc.

Barry

--

Barry Flynn
Complete Solutions DG


"docsis" <doc...@discussions.microsoft.com> wrote in message
news:B834DC8D-7644-442A...@microsoft.com...

docsis

unread,
Jul 5, 2010, 10:43:12 AM7/5/10
to
Thanks for your response. I actually figured out how to do this. Instead of
adding a new form using the wizard I added the form in the VBA IDE window.
Once I did this a could add the grid control. One thing to note is when you
add a userform in this manner the dispform function will not open it. You
will have to use the formname.open method.

"Barry Flynn" wrote:

> .
>

0 new messages