View Single Post
 
Old 01-28-2015, 11:53 PM
dsjk9190 dsjk9190 is offline Windows 8 Office 2010 64bit
Novice
 
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