Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 59
Default lists without listbox

Is there a that I can create a list (and add to it) without creating a listbox?

Private Sub CommandOK_Click()

Dim i As Integer
Dim sStr As String

Select Case True
Case CheckMachine.Value

Range("A1").Value = "Marketing"

If CheckMNew.Value = True Then
ListBAdd.AddItem "ProductManager"

ElseIf CheckMFFF.Value = True Then
ListBAdd.AddItem "ProductManager"
ListBAdd.AddItem "Director of Engineering"
ElseIf CheckMWarranty.Value = True Then
ListBAdd.AddItem "Director of Engineering"
ListBAdd.AddItem "Director of Service"
ListBAdd.AddItem "Quality Manager"
ElseIf CheckMDisc.Value = True Then
ListBAdd.AddItem "ProductManager"
End If
End Select

With ListBAdd
For i = 0 To .ListCount - 1
If i < .ListCount - 1 Then
sStr = sStr & .List(i) & " / "
Else
sStr = sStr & .List(i)
End If
Next i
End With
Range("A4").Value = sStr

End Sub



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Modification of listbox to listbox code Sam S via OfficeKB.com Excel Programming 0 July 28th 05 12:02 PM
listbox.value not equal to listbox.list(listbox.listindex,0) ARB Excel Programming 0 October 22nd 03 12:46 AM
Is refreshing listbox rowsource in listbox click event possible? Jeremy Gollehon[_2_] Excel Programming 4 September 25th 03 06:45 PM
Listbox lists Bob[_21_] Excel Programming 0 July 12th 03 07:09 PM
Listbox lists Bob[_21_] Excel Programming 0 July 11th 03 04:43 PM


All times are GMT +1. The time now is 12:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"