Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-06-2014, 01:35 PM
marksm33 marksm33 is offline Getting mult resps. selected in listbox to concatenate & paste at a bookmark in Word Windows 7 64bit Getting mult resps. selected in listbox to concatenate & paste at a bookmark in Word Office 2013
Novice
Getting mult resps. selected in listbox to concatenate & paste at a bookmark in Word
 
Join Date: Jan 2014
Posts: 12
marksm33 is on a distinguished road
Cool Getting mult resps. selected in listbox to concatenate & paste at a bookmark in Word

Hey, Everyone,



I'm a bit stuck and I'm hoping someone can get me to my next step.

I have a MS Word template that uses a Userform with a Listbox on it.

I have the code down to get the userform and listbox to appear with the possible selections. Where I'm falling down is how to use a command button (Select) so the user may select his/her responses and have them concatenate and paste into the Word document at a prescribed bookmark.

Here is the code that I am currently using. I've highlighted in red the part where I am stuck. I do not know what code to put where I've left a question mark:

Private Sub CmdSelect1_Click()
Dim BM1a1 As Range
Set BM1a1 = ActiveDocument.Bookmarks("BM1a1").Range
BM1a1.Text = ?WhatCodeDoIPutHere?
Me.Repaint
UF1a.Hide

End Sub

Private Sub LB1a_Click()

End Sub

Private Sub UserForm_Initialize()
With LB1a
.AddItem "Teacherís plans and practice indicate some awareness of prerequisite relationships, although such knowledge may be inaccurate or incomplete."
.AddItem "Teacherís plans and practice reflect a limited range of pedagogical approaches to the discipline or to the students."
.AddItem "Teacher displays solid knowledge of the important concepts in the discipline and how these relate to one another."
.AddItem "Teacherís plans and practice reflect accurate understanding of prerequisite relationships among topics and concepts."
.AddItem "Teacherís plans and practice reflect familiarity with a wide range of effective pedagogical approaches in the discipline."
.AddItem "Teacher displays extensive knowledge of the important concepts in the discipline and how these relate both to one another and to other disciplinesÖ.."
.AddItem "Teacherís plans and practice reflect understanding of prerequisite relationships among topics and concepts and a link to necessary cognitive structures by students to ensure understandingÖ.."
.AddItem "Teacherís plans and practice reflect familiarity with a wide range of effective pedagogical approaches in the discipline, anticipating student misconceptionsÖ.."
.AddItem ""
End With
lbl_Exit:
Exit Sub
End Sub

I've attached the MS Word form, as well. Any help would be appreciated!

Thanks,

Mark

Last edited by marksm33; 02-07-2014 at 06:37 PM.
Reply With Quote
  #2  
Old 02-06-2014, 03:34 PM
fumei fumei is offline Getting mult resps. selected in listbox to concatenate & paste at a bookmark in Word Windows 7 64bit Getting mult resps. selected in listbox to concatenate & paste at a bookmark in Word Office XP
Expert
 
Join Date: Jan 2013
Posts: 440
fumei is on a distinguished road
Default

No code and no attached.
Reply With Quote
  #3  
Old 02-06-2014, 05:32 PM
marksm33 marksm33 is offline Getting mult resps. selected in listbox to concatenate & paste at a bookmark in Word Windows 7 64bit Getting mult resps. selected in listbox to concatenate & paste at a bookmark in Word Office 2013
Novice
Getting mult resps. selected in listbox to concatenate & paste at a bookmark in Word
 
Join Date: Jan 2014
Posts: 12
marksm33 is on a distinguished road
Default Here is the Code and the Attachment...Sorry.

Quote:
Originally Posted by fumei View Post
No code and no attached.
Private Sub CmdSelect1_Click()
Dim BM1a1 As Range
Set BM1a1 = ActiveDocument.Bookmarks("BM1a1").Range
BM1a1.Text = ?WhatCodeDoIPutHere?
Me.Repaint
UF1a.Hide

End Sub

Private Sub LB1a_Click()

End Sub

Private Sub UserForm_Initialize()
With LB1a
.AddItem "Teacherís plans and practice indicate some awareness of prerequisite relationships, although such knowledge may be inaccurate or incomplete."
.AddItem "Teacherís plans and practice reflect a limited range of pedagogical approaches to the discipline or to the students."
.AddItem "Teacher displays solid knowledge of the important concepts in the discipline and how these relate to one another."
.AddItem "Teacherís plans and practice reflect accurate understanding of prerequisite relationships among topics and concepts."
.AddItem "Teacherís plans and practice reflect familiarity with a wide range of effective pedagogical approaches in the discipline."
.AddItem "Teacher displays extensive knowledge of the important concepts in the discipline and how these relate both to one another and to other disciplinesÖ.."
.AddItem "Teacherís plans and practice reflect understanding of prerequisite relationships among topics and concepts and a link to necessary cognitive structures by students to ensure understandingÖ.."
.AddItem "Teacherís plans and practice reflect familiarity with a wide range of effective pedagogical approaches in the discipline, anticipating student misconceptionsÖ.."
.AddItem ""
End With
lbl_Exit:
Exit Sub
End Sub
Attached Files
File Type: docx Sample.docx (21.3 KB, 6 views)
Reply With Quote
  #4  
Old 01-15-2015, 05:59 PM
scarda scarda is offline Getting mult resps. selected in listbox to concatenate & paste at a bookmark in Word Windows 8 Getting mult resps. selected in listbox to concatenate & paste at a bookmark in Word Office 2010 64bit
Novice
 
Join Date: Jan 2015
Posts: 5
scarda is on a distinguished road
Default Any update

marksm33 how did you go with doing sorting this one out??
Reply With Quote
Reply

Tags
concatenate, list box, multiselection

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting mult resps. selected in listbox to concatenate & paste at a bookmark in Word Concatenate function for displaying numbers in words officeboy09 Excel 13 08-09-2021 12:59 PM
How to use an ActiveX Control to insert a multi select listbox in Word marksm33 Word 2 01-29-2014 05:21 PM
Getting mult resps. selected in listbox to concatenate & paste at a bookmark in Word Multi-select listbox help gvibe@hotmail.com Word VBA 1 07-19-2013 10:54 AM
as the return value of another column, using Listbox? marreco Excel Programming 1 03-27-2012 12:48 PM
If, move and concatenate in VBA devcon Excel Programming 0 07-04-2011 12:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft