Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

EXCEL - Problem with adding text/data to listbox from VB.

Status
Not open for further replies.
chrisdq

chrisdq

Programmer
Joined
Nov 6, 2002
Messages
77
Location
US
EXCEL Could someone show me how to add text/Data to a listbox from VB?? THANKS.
 
Sort by date Sort by votes
Something like this:
Code: 
Private Sub CommandButton1_Click()
  ListBox1.Clear
  ListBox1.AddItem "This is data"
  ListBox1.AddItem "so is this"
  ListBox1.AddItem "This too"
End Sub
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bkoopers
  • Locked
  • Question Question
Problem with Excel pasting into filtered cells
Replies
1
Views
720
combo
combo
ladyck3
  • Question Question
Assistance with MS365 - Excel (its up to date) and Conditional Formatting
Replies
4
Views
108
Andrzejek
Andrzejek
renigar
  • Locked
  • Question Question
Having trouble with Excel Lookup
Replies
5
Views
1K
renigar
renigar
techguy2010
  • Locked
  • Question Question
Excel macro to send e-mail to multiple agents with a different body for each
Replies
3
Views
1K
techguy2010
techguy2010
BxWill
  • Question Question
MS EXCEL 2016 LINE CHART NOT DROP TO ZERO - USING NESTED IF AND COUNTIF
Replies
1
Views
157
combo
combo

Part and Inventory Search

Sponsor

Back
Top