newbie in VBA Drag and drop

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

den 2005 - 12 Dec 2006 11:29 GMT

Hi,

Do not know how can this be done if it is possible, the task is to import
and export data from and to database, but user can select from a list columns
what they want to add, there will be a dialog will appear and allow user to
select data to be included in a word document- "drag and drop" effect, how
can this be done or it is possible using VBA?

Thanks in advanced.

den2005

Signature

MCP Year 2005, Philippines

Reply to this Message

Doug Robbins - Word MVP - 12 Dec 2006 18:17 GMT

The following code in the initialize event of a userform will populate a
listbox on that form with data from a table in an Access database. Your
user could then select the record containing the data that they want to
insert into the document and you could have a command button on the userform
that executed the necessary code to do that.

To get started with userforms, see the article "How to create a Userform"
at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

Signature

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

> Hi,
>
[quoted text clipped - 10 lines]
>
> den2005

Reply to this Message

den 2005 - 13 Dec 2006 01:25 GMT

Hi Doug,

Are we talking about using VB6 or .net languages in doing this? Not quite
familar with any visual studio version 6 languages, I know a little about
vb6, so don't know what you are referring to, so you are saying it is
possible to do this drag and drop effect in vb6 w/ VBA?

Dennis

Signature

MCP Year 2005, Philippines

> The following code in the initialize event of a userform will populate a
> listbox on that form with data from a table in an Access database. Your
[quoted text clipped - 21 lines]
> >
> > den2005

Reply to this Message

Doug Robbins - Word MVP - 13 Dec 2006 04:37 GMT

I'm talking VBA (Visual Basic for Applications) though VB6 may be very
similar. We don't do no dot net here. (At least I don't)

Signature

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

> Hi Doug,
>
[quoted text clipped - 34 lines]
>> >
>> > den2005

Reply to this Message