Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-28-2015, 11:53 PM
dsjk9190 dsjk9190 is offline Link listbox (with multiple columns) to bookmark based on selection Windows 8 Link listbox (with multiple columns) to bookmark based on selection Office 2010 64bit
Novice
Link listbox (with multiple columns) to bookmark based on selection
 
Join Date: Jan 2015
Posts: 4
dsjk9190 is on a distinguished road
Default Link listbox (with multiple columns) to bookmark based on selection

I'm after some thoughts on creating a listbox on a userform (with multiple selections available), then have this linked to a particular bookmark. However the text that appears in the listbox isn't all of the wording I'd like to add, so I'm thinking of creating a second column.
Below is the first part of the code that I've worked out, however I want to try link a selection to a bookmark.



Private Sub UserForm_Initialize()
With Me.ListBox1Area
.ColumnCount = 2
.ColumnWidths = .Width & ",0"
.AddItem
.List(.ListCount - 1, 0) = ""
.AddItem
.List(.ListCount - 1, 0) = "Area 1"
.List(.ListCount - 1, 1) = "Description...."
.AddItem
.List(.ListCount - 1, 0) = "Area 2"
.List(.ListCount - 1, 1) = "Description...."
.ListIndex = 0
End With
End Sub
Reply With Quote
 

Tags
listbox bookmark



Similar Threads
Thread Thread Starter Forum Replies Last Post
Link listbox (with multiple columns) to bookmark based on selection Moving Selected Items from a Multiselect Listbox on a userform to a bookmark in Word marksm33 Word VBA 3 01-15-2015 07:55 PM
Link listbox (with multiple columns) to bookmark based on selection Getting mult resps. selected in listbox to concatenate & paste at a bookmark in Word marksm33 Word VBA 3 01-15-2015 05:59 PM
Link listbox (with multiple columns) to bookmark based on selection This is a Userform LIstbox queston: A variable does not set to the value of a listbox CatMan Excel 1 08-08-2014 09:41 AM
Link listbox (with multiple columns) to bookmark based on selection TOC: Link to bookmark or image Mijin Word 2 09-22-2011 03:14 AM
Link listbox (with multiple columns) to bookmark based on selection Putting a bookmark on a REF field in the selection b0x4it Word VBA 4 05-26-2011 01:14 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:35 AM.


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