Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002

    Unanswered: Excel VBA listbox won't accept text value

    I have a form with 4 listboxes. Each one is linked to a cell on a spreadsheet, using the control source property. When the form initializes, I want the listboxes to show as selected, the values contained on the linked cells. My understanding of control source property is that it should just work....but what does happen is that the listbox changes the control source cell to contain whatever value was selected when the listbox was saved in design mode. not every time, not every listbox; but often enough that I can't count on the listboxes showing the current values correctly.

    I tried using code instead of the control source property. on the listbox_click event, I set the cell equal to the selected value.
    workbook.sheets("setup").cells(48,14) = lstEndYear.value

    on the form activate event, i tried setting the listbox value equal to the value in the cell:

    lstEndYear.Text = workbook.sheets("setup").cells(48,14)

    When I walk through the code step by step, it sets lstEndYear.Text equal to "2002" like I want, but then the listbox click event fires, and about 60% of the time, it resets the lstEndYear.text to "1998" which is the value it had at design time. If I change it at design time to be empty(nothing selected) then it simply changes my value when it runs, to empty.

    It's driving me crazy. it just shouldn't be this hard.

  2. #2
    Join Date
    Aug 2003

    Question Any luck with the Excel VBA listbox accepting text value?

    I am having the same problem and have wasted hours on it, no solution yet, although it's driving me crazy, I'm still determined that there must be a simple error on my part.

    It's been a while since you posted this, but please let me know if you had any sucess.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts