Results 1 to 5 of 5

Select UserForm ListBox Value For Closed WB Input

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Select UserForm ListBox Value For Closed WB Input

    Hi all,

    Seems my problems are never ending.

    Using a userforms listbox item. BTW only 1 item is listed. I'm trying to select that
    item with code so the value/text can be copied over to an previously closed workbook(WB). Currently, I'm trying to select the item using the following:

    Dim LB as string
    Me.ListBox5.Selected(Me.ListBox5.ListCount - 1) = True
    LB5 = Me.ListBox5
    'more code then
    Msgbox LB5
    Sheets(X).Cells(FindIt.Row, FindIt.Column).Offset(0, 1).Value = LB5
    It seems that the method that I'm using to select the list box items doesn't always work.
    My MsgBox will return a empty box. Where if I walk through the code and manually select the listbox I will get LB5 to hold the listbox5 value.


    I've been trying to figure this out over the past few days. Any help as always much appreciated.

    Thanks,

    BDB
    Last edited by bdb1974; 04-19-2011 at 06:03 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1