Consulting

Results 1 to 2 of 2

Thread: Clear ComboBox

  1. #1

    Clear ComboBox

    Hi everybody. I have a UserForm that picks data from a table by selecting one data set via choosing the name of the data set in a combo box so that the accompanying data can be changed. If I change one data set with the OK button and want to change another one without closing and reopening the form I am able to clear the rest of the controls in the form, but not the combo box with which I select the data sets. Somebody any idea on that?? Hope the description of the problem was not too weird.

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    [VBA]

    ComboBox1.ListIndex = -1
    [/vba]
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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