Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Desperate for help......!!!!!!!!

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    43
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've produced a userform with a drop-down list with items such as chair, table, bed etc. When i select one of them (eg. chair) , and press the command button to select the item, it flashes up with all of them and goes back to the original chosen one.

    HELP! Whats going on?!

    How do i get them to show up on the spreadsheet individually??!!!

  2. #2
    Board Regular hennahairgel's Avatar
    Join Date
    Feb 2002
    Location
    Bristol, England
    Posts
    63
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    you need a bit of code in the userform. eg

    For p = 0 To ListBox1.ListCount - 1
    If ListBox1.Selected(p) Then

    enter your code in here....

    End If
    Next p

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    43
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What is 'p'?

    Is that where i put the item?

  4. #4
    Board Regular hennahairgel's Avatar
    Join Date
    Feb 2002
    Location
    Bristol, England
    Posts
    63
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm just using it as a varible!
    It could be anything, but is used in this to as the step counter in the FOR loop.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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