I am working on an assignment and cannot figure out what I've done wrong. I am trying to get the states listed in A1:A5 to list in a listbox when the command button is clicked. I am getting an error: 1ststates not defined.
Here is what my excel page looks like:
ExcelStates.jpg
And my code:
Any help is much appreciated.
Please Login or Register to view this content.
Last edited by LadyB; 04-12-2013 at 03:39 PM.
Change the "A" in both lines to a 1Please Login or Register to view this content.
Elegant Simplicity............. Not Always
That doesn't change the error of "Variable not defined" that I keep getting.Originally Posted by AndyLitch
Change the "A" in both lines to a 1Please Login or Register to view this content.
at the top of the code put Dim introwindex as integer
I still get the same error. It highlights the 1stStates. I'm not sure how to define it.
Can you upload the workbook? It'll save time..
I listed at the top
Dim introwindex As Integer
Dim lstStates As ListBox
Dim cboStates As ComboBox
Now when I click the fill list I get a runtime error and it highlights "lstStates.AddItem Cells(intRowIndex + 1, "A")" in yellow.
If i knew how, I have zipped it, but see no upload file option.
lstStates.AddItem(Cells(intRowIndex + 1, 1).value)
I figured it out, I hadn't named my list box or Combo box correctly, but thanks for helping.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks